Please Help!
Every time I try to add a new record to my database I get this error:

Run-Time Error: '-2147467259(80004005)':
You cannot Add or Change A record because a related record is required in table 'CUST'.

The code that it bombs on is:

Adodc1.Recordset.Update

The thing that kills me is that I am not updating the customer table, just the orders table. This program will run OK if I do not 'enforce referential intergrity' with the relationships between the tables in the database (in Access). The problem with that is that the customer # is not written to the orders table. It actually leaves that field blank.
I know that this should be easy to answer, but I am baffled. The other thing is that I am using Microsoft Jet 4.0, not 3.51. Every example in these two books I own uses 3.51, but VB 6.0 doesn't reckognize that version of Access.
Thak You for any help!

Joe