Can anyone help???

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

Guest

Hi

I have two table (tblCustomerDetails & tblDebtors). On a form I created I
have a combo-box that is based on the tblCustomerDetails where it populates
the fields, Customer Number & Name. When I go to save a new record, i get the
following error:

You cannot add or change a record as a related field is required for
tblCustomerDetails.
The relationship is one(tblCustomerDetails.CustomerNumber) to
many(tblDebtors.CustomerNumber)

Please if anyone knows how I might fix this it would be greatly appreciated.
 
The best way to handle this is with a form for tblCustomerDetails and placing
a subform on it based on tblDebtors.

If your relationship is formalized in the Relationship Window with
referintal integrity enabled, the Form Wizard or SubForm Wizard should walk
you through the process plus keep the tables properly joined.
 
Thanks Jerry. This method works.

Jerry Whittle said:
The best way to handle this is with a form for tblCustomerDetails and placing
a subform on it based on tblDebtors.

If your relationship is formalized in the Relationship Window with
referintal integrity enabled, the Form Wizard or SubForm Wizard should walk
you through the process plus keep the tables properly joined.
Click to expand...
 
Back
Top