Assign Serial Number By Type
I have a simple database of furniture. There are 10 types of furniture (desk, chair, cabinet etc.). Each has a primary key ID "FurnitureID".
On new record creation, is it possible to auto-generate a second serial ID "TypeID" within a certain range based on the object type? I.e. I'd like to have a field where all chairs can be numbered 2001, 2002, 2003... and all desks to be 1001, 1002, 1003...cabinets 9001, 9002, 9003.
My assumption is that I there is no way to have filemaker auto-generate the main primary key ID based on type and within these varying ranges. Even if that is possible, I'm not convinced its preferable.
Thanks for any help!