Linking Id throughout forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create forms for data entry to a database that will eventually be linked to a GIS
I have many forms each with their own table and all with an Entry ID field
The user will start at a welcome form and enter data, working their way through to the end where they click a button that saves that entry and goes back to the welcome and to the next consecutive Entry ID
I need to link the entry ID's right through so that they display on each of the form with the same number for each entry but I need each ID to be recorded in the Entry ID field for each table. I am able to link the forms to the first so that it displays the ID on each form but have been unable to get it to record the ID in each of the tables
Please someone help me!
Thanks in advance
 
Mel

How is your data designed, such that you have multiple tables, each with an
identical field ("EntryID")?

More info, please...

Jeff Boyce
<Access MVP>
 
Yes, thats right each form has a seperate table each with a field called "Entry ID" which is the key field

-Mel
 
Mel

I was asking for more information about what kind of data you are storing in
multiple tables, each with the same name for an ID/key field.

Jeff Boyce
<Access MVP>
 
Back
Top