I've debated the cardinality of a table relationship. Each unique rowid can select from one on up to 250 values, for a miximum of six times. (presently six col's for this in a table -- which assumes a one-to-many relation). Even if this is a many-to-many, it may be easier to manage out of the existing table (by drop menus, since I am limiting total # of results).
If a statement filters like so, will this Select by the zipcol first (a zip code) as a condition before searching all other six cols in the table. This is a memory question:
SELECT name WHERE zipcol = "55098" AND ((col1 OR col2 OR col3 OR col4 OR col5 OR col6) = 10)
Please forget about syntax, this is a table design question.