I have a MASTER table that keeps track of customers, addresses, etc.  When the customer, I open up a secondary table and copy to this table the "auto number", customer name, and assign a salesman based on the territory.  After this data is entered, and during the same call, the customer may ask or need additional information.  I want to duplicate this record, INCLUDING the auto number and then edit the fields to make necessary changes.  When I use the "create duplicate" record everything is copied except the "auto number" from the master table.  This field is often left blank.  How can I insure the "auto number" get copied into the duplicate record.  I use this auto number later on in my database, so its important the the auto number is copied into the new record.