>David, where in the original question You point to OleDB? :o))

Yes, thanks Borislav, you answered my question spot on. But you know, when you give them something, these users always want more :-)

>*** Update
I think with OleDb Should be look like this:

1. Begin transaciotn
2. Insert into Parent Table
3. Refresh the Parent Cursor/Record Set
4. GO TO end of Cursor/Record set
5. Store AUTOINC value to a variable
6. INSERT into child table

Thanks again, I will try this ! Is it safe from concurrent access - I mean, if someone inserts between 2 and 3, won't I get her inserted value instead of mine ?