Problem with 1-1 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access and new to this forum
This is easy I think but I am stuck with it

My application has 2 tables in 1-1 relation (tblCustPersonal and
tblCustWork) with common pk CustID. There are other queries/forms/reports
that come from these. Using excel I paste about 500 records into
tblCustPersonal. Then I have to copy the CustID fields and paste them into
tblCustWork. if I do not do this then my form frmCustWork can not be used to
enter data into tblCustWork.

I can solve this by combining the 2 tables into 1 but I am hoping I can keep
them apart. What is solution please? What am I missing?
 
If you create a mainform (tblCustPersonal) with a subform (tblCustWork) and
set the link master/child properties, you shouldn't have to do anything.
When you create a record in the child form, it'll automatically pick up the
CustID from the main form.
 
Back
Top