Copying a field from one form to another

  • Thread starter Thread starter Brandon Coates via AccessMonster.com
  • Start date Start date
B

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


Brandon Coates via AccessMonster.com said:
Hello,
I have a table employees with social security as the primary key. I have
Click to expand...
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).
 
Back
Top