Config Table -- Help!

[Pariah]

Describing this will be tough...

I've got a table that goes something like this:

Category Group1 Group2 Group3
Text Data Bool Bool Bool
More Data Bool Bool Bool

The idea being that I want to use the boolean fields (group 1, 2, etc.)
to denote whether the 'category' applies to the group.

Eg. 'text data' applies to groups 1 and 2, but not 3.

The idea being to then use a single query that will then return
only the categories that apply to the group.

I don't have any problem doing this with multiple queries (which are
in essence, identical save for the 'group' field).

But how do I do it with a single query (that gets the field to select
from from a form, for example).

Thanks

 

[tina]

suggest you re-evaluate your table design. putting data in field names
(Group1, Group2, Group3) is incorrect table design. you can Google for
"table normalization", or do a Find here in the newsgroups, for more
information on proper table design.

hth