Complete table fields from a form

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
Also, if you are using subforms make sure the link master and child fields
are set to your ID number field.
 
Back
Top