>Mark,
>
>In a situation where both parent and child records are being added in the same process it is necessary to know the parent’s primary key into order to add the child records. I use the same approach when updating SQL Server and Oracle data. I call a stored procedure using SQLExec() to retrieve the next available ID. Default values work great if your adding or appending multiple records but I prefer to handle adding primary id’s in my business classes in a order-entry environment.

Yes, I do have to do the same in those situations.

>BTW, how do I setup my account to copy the original message into my reply?

You should have a link regarding AutoQuote at the bottom of this and every message.