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...