Not really sure what I need...

[memilanuk]

I have three tables, one with competitor info, one with special categories that the competitors may fit into according to the rule book, and a many-to-many junction table.

The categories are fairly general... things like 'Senior, Grand Senior, Junior, Intermediate Junior, Sub Junior, Collegiate, Civilian, Police, Military, Woman'. A competitor can be more than one of these categories like 'Civilian' and 'Grand Senior', or 'Police' and 'Woman', etc. hence the many-to-many table with foreign keys corresponding to the id fields of the competitor info & special category tables.

The problem I'm having is that if this was done on say, a paper form... you'd most likely see a series of check boxes with instructions that said 'Check all that apply'. Access kind of allows this (I think) by way of an option group control where I could have a check box for each category and then store multiple values in a field of the original competitor info table... but I think that violates all sorts of rules of database design rules, if I'm not mistaken

So... what would be the correct way of doing something like this, inside a tabbed control?

Thanks,

Monte

 

[SpentGeezer]

Set up the form with the checkboxes. Then have a completed button. This button needs code that will check each checkbox and if checked created a new record in the table for that competitor.

 

[missinglinq]

...'Check all that apply'. Access kind of allows this (I think) by way of an option group control...

Actually an Option Group does the exact opposite! In an Option Group one and only one option may be selected!

Linq ;0)>