AnsweredAssumed Answered

Key Field Q: How to/ Multi part inventory number?

Question asked by longhairdontcare on Jun 12, 2014
Latest reply on Jun 12, 2014 by philmodjunk

Title

Key Field Q: How to/ Multi part inventory number?

Post

     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?

      

     Thank you FM forum!cool

Outcomes