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 ?