Add information in 2 tables 1

[Kindi]

I have a form where a user enters information, and the primary key is the autonumber created by access. Some information must go into another table, I understand how to place information into the second table, but how can the second table have the same primary key number that is created for the first table. Would a trigger need to be coded or does access has a simpler approach?

Please Help!

Thanks
Kindi

 

[ghubbell]

Hi Kindi,
You probably don't want or need to see the "foreign" key from the other table 'cause it's supposed to be the same as the "primary" . Place it on your form visible or not and set it's "default value" equal to your other fields value...something like this:

=Forms![NameOfYourForm]![NameOfYourPrimaryKeyField]

Now by default, any entry made in to the second tables fields on that form should "take" the primary key's value.
Write back if you have any trouble... Gord
ghubbell@total.net