Received: from websales.com (IDENT:root@websales.com [192.153.125.97]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA83409 for ; Tue, 30 Nov 1999 22:27:40 -0500 (EST) (envelope-from cgriffin@websales.com) Received: from [207.67.207.131] (webcc-isdn-131.webcc.net [207.67.207.131]) by websales.com (8.9.3/8.8.5) with ESMTP id TAA26007 for ; Tue, 30 Nov 1999 19:30:22 -0800 User-Agent: Microsoft Outlook Express Macintosh Edition - 5.0 (1513) Date: Tue, 30 Nov 1999 19:26:55 -0800 Subject: Many booleans From: Chris Griffin To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit I am working on a DB that keeps information on potential job candidates. One of the pieces of information I need to keep is where they are willing to relocate. The choices are broken down into 5 regions of the US and northern and southern California. There are also choices for the continents plus US and world. If the user puts in a search for the US it needs to match any of the us regions. If they select any region it needs to match any records with US or world selected. Currently I have separate boolean fields for each selection. Is there a better way to do this? Thanks.