Many-to-many relationship form design

[BlueJacket]

Hokay, so...

I have a Judges table, a County Information table, and a Judges_County joining table (since there are many judges in one county and there are some judges that preside over many counties).

The kind of form I was thinking about was my main form would be my Judge Information form with all the corresponding fields and then a subform that would pop up for them (via button) to select all the counties that judge presides over. What would be the best way to go about this? Should the subform just be a multiple columned list of all the counties with check boxes next to each one? How could I make that work?

 

[pbaldy]

Normally the subform would only list those that the judge presides over. You could enter them one-by-one, or use something like this:

http://www.baldyweb.com/MultiselectAppend.htm