I am pretty new to VB, so please excuse the how elementery
this question may be.

I am trying to update a database that from a FORM in VB.
Some of the fields (textboxes in VB) are linked to certain
tables, others to other tables using the Datafield Property. I am updating through and ADO Data
Control using Jet 4.0.

I am trying to update a table called 'ORDERS' that has a
link to the 'CUSTOMER' table. When I use "enforce
referential intergrity" in Access, it bombs. The error
that I get is:

Run-Time Error: '-2147467259(80004005)':
You cannot add or change a record because a relaed record
is required in 'CUSTOMER'.

I am not updating the Customer table. When I remove the
referential intergrity, it works, but the related fields
remain null.

Thank you for any help.