Might you:
If it isn't a multiuser situation: 1. Disable autonum on the destination table 2. Copy the source data to this destination table 3. Capture the max(autonumbered column) from this updated destination table 4. Re-Enable autonum on the destination table using ( max(autonumbered column) + 1) as the starting value (with NONUM) If it is, I don't know. Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, August 19, 2015 11:31 AM To: [email protected] Subject: [RBASE-L] - copy data from table to another table including autonumber I want to copy data from one table into another table. The problem is I have one column in the destination that is an autonumber field. I want to put the number from the source table in that autonumber field as I have already captured it using the nextnum function. Other than using unload/load does anybody know a way to achieve this? TIA Dan Goldberg
