Key Field Q: How to/ Multi part inventory number?
I'm creating a custom database for an art gallery and am stuck figuring out how to do the following:
The gallery assigns the following format to each artwork's Inventory #: Artist Initials, Category, Number
For example: SSPT001 (Simon Says, Painting, 001)
For now, I have a three-digit serial number generated on creation as the key field. How do I add the first two parts of the inventory number (initials and category) ? Also important to note that there are several categories and the serial numbers need to reflect the next value for that category AND I will be importing data from excel files which already have inventory numbers.
How do I proceed?