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.