table relationship issue

[oskar_diaz]

I think my problem is with the relationship or it could be with the keys. I have made 6 tables all with auto num. I need to input the data into about 5 people. Need seperate entries for each

so when i add a name in the main table it should create autonumber 2 in all other tables. But this is not the case.


can someon advise

 

[KingKong]

Oskar,

I think you will have to do some redesign on your tables.
You've linked your tables via the PK (ID), what you really want to do is link them through use of a FK (Foreign Key).

Grtz,

Peter.

 

[jfgambit]

You definately need to redesign your relationships. From what I can determine you need have one main table "Safety" and child tables that should all be linked to this table via a one-to-many relationship between the ID number.

As for adding a subsiquesnt ID number in the other tables, this only need to take place when the data is added into the tables via a form. Each of these tables can be a subform on the Main Safetly table form. The Default Value for the ID on each of these subforms would be set to [FORMS]![MAINFORM]![ID].

Here is a really quick example

 

[oskar_diaz]

thank you very much for your help this is frustrating me. Can you take a look at this db i cant get it to work i get a ID key error.

thank you very much

when trying to establish one to many relationship