Need some guidance here... I am trying to copy the data in one record to a new record in the same table, then change the JobNo field to some new Job umber that I already have and validated as unique.

The problem is that the table has an AutoInc field named "ipkey", and VFP does not want to let me do a GATHER for obvious reasons.

So, I understand why it has this limitation because of autoinc, I just want to know how one works around it.

Presently, to get around it, I am doing a REPLACE command on every field except ipkey, but I was hoping to use the SCATTER NAME / GATHER NAME method to avoid having to list out every field, and so I would have code that is independent of the field names.

Here's what I wanted to use:

Select 0
Use Jobs order jobno
... navigate to the desired record ..
SCATTER NAME loCurrentJob
Append Blank
Gather NAME loCurrentJob
replace JobNo with lcNewJobNo && a passed in value, already validated