blindlemonray
Technical User
Can anyone Help? I have a DB where there is a "number" field which is used as the primary key, but also as a reference number for the customer.
I need to change the field to an "autonumber" field so that when more records are added they will have unique ref number.... but keep all the current reference (primary key) numbers as they are attached to all the current records!!!
Can this be done? or am I just dreaming!! Any help on this would be much appriciated!!
I need to change the field to an "autonumber" field so that when more records are added they will have unique ref number.... but keep all the current reference (primary key) numbers as they are attached to all the current records!!!
Can this be done? or am I just dreaming!! Any help on this would be much appriciated!!