I need to insert a record into a MySQL table with a auto increment id field controlled by the SQL server. After insert I need to get the newly inserted record's id and use that in the creation of the child records for the document. I have tried the Inserted exit on Insert but to no avail.
What am I doing wrong?
For best results, use the Firefox browser..