Primary Key/Foreign Key Tables

[HL]

Hello,

I have two tables in which SNO is the primary key for Table1 and SNO is the
foreign key for Table2. In Table1, I made SNO an auto number while in Table2
SNO is just a number.

I have already established a relationship between the two tables (1:M). When
the user enters information into Table1 how can the foreign key automatically
be inserted into table2? Since SNO is an auto number in Table1, the user
doesn't have to input a number, access does it for me. However, I need that
same number to show up in Table2 because information will be entered into
Table2 at a later date (maybe not the same day that Table1 receives its
info).

How can I do this?

 

[Lynn Trapp]

Access doesn't suppor table level triggers and, therefore, you will need to
use a form/subform for your data entry.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html