I have a database holding information on advice given to cutomers and their personal details.

I want to generate a script that can be run from a button that copies all of the clients details to a new record.

However the client ID (number field) is auto generated in serial and i do not want the old client id to overwrite this when the copy is done.(im presuming this will happen, correct me if im wrong!)

The number of fields is large so i do not want to set up individual steps for each field.

Is there a way to copy the whole record except for that one field?

Any help would be appreciated.

Thanks

Duplicating a record will not duplicate an auto-entered serial field. It will be set with the next available serial.