Adding new record to all tables for 1 table primary key entry

[tanzania]

Hi, I have 7 tables in my database and 1 form corresponding to all the fields in these tables (linked by a query by recordsource). My problem is that the form will only show a record if ALL 7 tables have manually had the primary key entered (not good when i have information that needs to be added at different times). How can I make it such that if I create a new record on the form that all primary key fields will be updated, and this record will be present every time i open my the form??

Cheers

Tania

 

[Oldsoftboss]

You need to look at your table structure and normalize the tables. I feel you need a main table and some related tables, then use a form and subforms.

Maybe post a sample Db fro us to look at.

Dave

 

[tanzania]

mmm, that doesnt really help alot as i dont think making relational tables to 1 main one is applicable to my application. What I have been trying to do is insert a set of embedded sheets into my first table but get stuck at the second layer.Not sure about posting the databse as it is to be included as part of a product we are selling.

Cheers

Tania