Hi Bonnie,

Again thanks for the reply, it's really appreciated...

I think I'm going to continue down the road of using the command builder for a little longer. I guess I'll have to use the MS recommended approach of running an SP from the insertcommand.

If this doesn't pan out then I might have to have a look at having a dedicated SP for the select / update and delete operations.

I'm assuming your SP's take parameters from the client and insert them into the correct field returning the pkey field to the client?

I never thought of using foxpro to generate the skeleton commands!

Many thanks , Bernard