Problem adding new record

[Natasha]

I have a service history form which has all the customer information coming
from a customer table and all the rest of the cooler information from a
cooler history table. When i go to add or change a new history it says i
cant because a related record is required in table 'tblcustomer'. The 2
tables are linked by customerID.
Can someone help please
Natasha

 

[J]

Make sure you have the relationship set as "One to Many" from
tblCustomers to tblHistory, respectively.

Make sure there are no default values in your form, especially in those
pesky check boxes.

Then make sure you have chosen a customer ID to link to.




An easy way to check if the problem is your form or your relationship
is to create a query of all fields in both tables. Then try to add a
line item to your query and start a new entry by manually typing in a
customerID in the right field. If you can complete your entry, the
problem is your form. If you can't complete your entry, the problem is
in your relationship/table design.

~J