Can anyone help???

[Enigo]

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.

 

[Jerry Whittle]

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.

 

[Enigo]

Thanks Jerry. This method works.

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.