Combo Box Lookup

[Zeppelin]

I have a table that lists Group Names that I use to feed a combo box.

Group AAA
Group AAB
Group CCA
Group CCB

I wan to be able to list combinations of groups as a selection for the combo box like:

Group AAA
Group AAB
Group CCA
Group CCB
Group AAA & CCA
Group CCA & CCB

Also I would like to use a wildcard

Group AAA
Group AAB
Group CCA
Group CCB
Group AAA & CCA
Group CCA & CCB
Group A*
Group C*

How do I enter in to the table multiple choices to feed the combo box (which feeds the querie) ?

How do I use a wildcard?

 

[Pat Hartman]

If something can belong to more than one group, you need an additional table to handle the many-to-many relationship.

tblGroupRelation
GroupID (pk field 1)
OtherID (pk field 2)

If you want to select multiple groups as selection criteria for a query, use a multi-select list box. There are code samples available here for building the In() clause that you will need.