AnsweredAssumed Answered

Assign Serial Number By Type

Question asked by oman on Oct 13, 2014
Latest reply on Oct 15, 2014 by philmodjunk


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!