So I am creating a new table by pasting an excel spreadsheet of existing parts, the parts currently have no part number.
I want to create an AutoNumber field that generates a fixed prefix followed by a random 5 digit positive integer.
What I am doing currently:
Creating a new field and setting the datatype to Autonumber
Set new values to Randon
In Format typing by prefix plus 5 zeros to indicate 5 digits: "RES-"00000
Tried all combinations of options for indexed.
This generates a sequential set of numbers in the form RES-00001, RES-00002.... in the existing data records which is not what I want, I want it to be random.
Every new record has ######## in the autonumber field.
How can I do what I want?
Assign a random, unordered number following a prefix, to a field in existing records with no repeats
All new records to automatically have a random number assigned (following a prefix) with no duplicates with existing records
Hopefully, you all get what I mean as I'm not the best at explaining.
I want to create an AutoNumber field that generates a fixed prefix followed by a random 5 digit positive integer.
What I am doing currently:
Creating a new field and setting the datatype to Autonumber
Set new values to Randon
In Format typing by prefix plus 5 zeros to indicate 5 digits: "RES-"00000
Tried all combinations of options for indexed.
This generates a sequential set of numbers in the form RES-00001, RES-00002.... in the existing data records which is not what I want, I want it to be random.
Every new record has ######## in the autonumber field.
How can I do what I want?
Assign a random, unordered number following a prefix, to a field in existing records with no repeats
All new records to automatically have a random number assigned (following a prefix) with no duplicates with existing records
Hopefully, you all get what I mean as I'm not the best at explaining.