Copying a field from one form to another

[Brandon Coates via AccessMonster.com]

Hello,
I have a table employees with social security as the primary key. I have three other tables that are related to that primary key. How do I keep the Social security number consistent when I am switching between forms? Currently I have to input the social security into the new record in any of the other three tables. (The tables are being viewed as forms).
Hope that isnt to confusing
bcoates529 <at> hotmail <dot> com

 

[tina]

if you add the other three forms - as subforms - to the mainform
(tblEmployees), and set the Child and Master links in the subform controls
to the SSN primary/foreign key fields, Access will enter the foreign key SSN
automatically when you add a record to a subform.

hth

Hello,
I have a table employees with social security as the primary key. I have

three other tables that are related to that primary key. How do I keep the
Social security number consistent when I am switching between forms?
Currently I have to input the social security into the new record in any of
the other three tables. (The tables are being viewed as forms).