Upon open form from copy PK text ID into another table PK

V

Vince

Hi,

Can someone help this newbie? I am fairly familiar with
the basics of MS Access. But just can't figure out where
to look for this one:

I have 3 tables OrderTbl, NoticeofBillingTbl,
NotAvailableTbl. These tables have a relationship of 1 to
1 (TO segregate the data instead of having one BIG flat
table)

The user will always begin data entry with the OrderTbl
but then they will choose whether the order will be
completed with NotAvailable or NoticeofBilling and not
both.

Because I set the primary keys the same for all tables and
a required field I would like to have the PK in the
OrderTbl to automatically copy and pasted into the
NoticeofBillingTbl or NotAvailableTbl when the user
request the table via a form.

Can Someone help!?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy text field from one form to another form upon open 5
Combine data without the PK 6
Setting values into a table using the PK of the just created record 1
Data entry for a table from a form 1
A newbie paradox: is this a PK-FK (relationship) problem, orprogramming problem? 32
Impor xls to acceess table with Autonumeric PK 0
Update a value in the table upon clicking a button 1
Trouble Creating Form 5

Top