Insert into child table fails

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
 
T

The Grim Reaper

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top