Related Combo Boxes..proper table setup??

[Franky G]

Hi,

I have four groups, each group has various reports available to them.

I want to use 2 combo boxes, one to select the group, and then the 2nd combo box to populate with the appropriate reports. What is the best way to set up the tables for this purpose?

I'm having trouble setting up the tables for a one to many relationship between Groups and letters. Any suggestions would be very helpful,

Thanks

Franky

 

[Franky G]

Never Mind...I got it sorted by deleting table and recreating them from scratch along with relationships.

Franky