How to add a auto created key to subsequent tables

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

Guest

This is my first time creating a access application and would like to use a
auto created sequence id when the user first logins in as the key for each
subsequent table entry. I want to push the key out to the other tables so I
don't have redundant data. How would I copy this key into the other tables?
I use forms with sub forms for data entry and would like for this to happen
in the back ground.

Thanks in advance for your help.
 
Use a datatype of Autonumber as primary key in the table. Use Number -
Integer in the other tables. Set a one-to-many relation from the primary to
foreign keys of the other tables.
Use forms/subforms with the Master/Child links using the primary/foreign keys.
 
Hi,
I created the one-to-may relationship between the main and each resulting
database that I want the autocreated key pushed out to and then used subforms
and created the Master/Child link but it does not update the field.
 
The autonumber key field is normally not display in either form.

As you add new records to the many side of the relations what does it put in
the field?

Can you save a new record?
 
Karl
No it doesn't update the field in any of the tables.
They have the same name and they have the one to many relationship with the
child\master properties filled in correctly.
Thanks for helping me
 
Back
Top