How to add a auto created key to subsequent tables

C

Connie

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.
 
K

KARL DEWEY

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.
 
C

Connie

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.
 
K

KARL DEWEY

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?
 
C

Connie

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
 
Top