Complete table fields from a form

[Pete]

Hi
I have 5 tables joined together with a many to many
relationship on an index number field which is in each
table.
I have a form which enters information into each field of
each table when I enter a new record.However the index
number field on the form enters the number only in the
first table. The index number is the same in the the
other 4 tables. Is thee a way to automatically insert the
new record index number into the other 4 tables?
Tried but cannot find a solution, help appreciated
Thanks
Pete

 

[MacDermott]

Have you tried enforcing referential integrity, with a cascade update?
- Turtle

 

[Reggie]

Also, if you are using subforms make sure the link master and child fields
are set to your ID number field.