Insert into child table fails

  • Thread starter Thread starter PAUL
  • Start date Start date
P

PAUL

Hello,
I have 2 access tables (parent and child) related this way:

Parent Child
ID--------->ParentID

I add a new record into the parent table in my code and then add a new
record intop the child table using the parent id as the value for the
ParentID field.
However after I do a dataset update the new record appears in the parent
table but not in the child table. No errors are flagged.

Enforce constraints is true for the dataset and I have a relation set set up
in the dataset for the tables between the required fields.

Anybody got any ideas?

Cheers
Paul
 
I think you'll have to post the relevent piece of code before anyone can
help with that one.
 
Back
Top