Can anybody help with the following?
I have an Autonumber field as my Primary key. I want to replicate my Database and understand (have tried) that the Autonumber cannot be maintained.
However, is there a way, perhaps using the DMAX function instead, whereby I can continue from my last number in what was the 'Autonumber' derived field instead of using the random number option or the Date/Time option as described in the various Microsoft Help topics I have read?
Many thanks in advance.
I have an Autonumber field as my Primary key. I want to replicate my Database and understand (have tried) that the Autonumber cannot be maintained.
However, is there a way, perhaps using the DMAX function instead, whereby I can continue from my last number in what was the 'Autonumber' derived field instead of using the random number option or the Date/Time option as described in the various Microsoft Help topics I have read?
Many thanks in advance.
