Hi James, thanks for the reply.

>You need to wrap the process into a transaction and then update the counter first and get the PK value and then commit the update. I prefer to do this with a stored procedure that way you only have one call to the database to get the new value.

Looks like one of these methods is the way to go. I have code suggestions for both, which I will be trying-out soon.

Regards,
Alan