Access 2003 Subfrom Help??

[Skins64]

Ok, I have a database that consists of a Contacts table (general contact data). I have three other tables, Items which consists 10 items contacts can order (free)...this is yes/no check box. Another table for trainings attended. Last table contains a couple newsletters contacts may sign up for, check box. I have developed a tabbed form,from the contact table data. I,of course, want to develop additional tabs for, Items, Trainings, and Newsletters....when I create the additional subforms as tabs, if I check that Joe Schmoe attended a training, it remains for all the records, in other words my subforms are not record specific. If I check that Joe Schmoe ordered a PSA then it remains as you go to Cindy Lue's record, showing that Condy ordered the same PSA.

Does this make sense? I would appreciate any help.

thanks

 

[mhartman1]

Hello:
You have a structural problem with your database design. You need to make a Primary table and then relate your ORDERS table, TRAINING table, and NEWSLETTER table to the main table via a Primary - Foreign key arrangement.
then place each table on the tab sheet tab.

Regards
Mark

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886