David, where in the original question You point to OleDB? :o))
*** 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
>
>BEGIN TRANSACTION
>INSERT INTO the parent table (fld2, fld2) VALUES (value_for_fld2, value_for_fld3)
>fld1_value = the parent table.Fld1
>INSERT INTO the child table (Fld_with_value_for_paren_table_Fld1) VALUES (fld1_value).
>END TRANSACTION
>
>
>Oh, so simple :-)
>
>But I guess that it will not work when I will be accessing a distant DB through Foxpro OleDb provider, will it ?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.