Hi
I have an app that copies records to SQL and it works fine I wanted to try it against VFP tables but it crashes. It adds the first record fine but then return the error

"Additional information: Column 'pk' is constrained to be unique. Value '' is already present."

I have set the primary field "pk" as AutoInc and have a primary index on it. If I add records at the command window it works ok. So what have I forgotten to do?
TIA
Stuart