5 Replies Latest reply on Oct 15, 2014 7:03 AM by philmodjunk

    Assign Serial Number By Type

    oman

      Title

      Assign Serial Number By Type

      Post

      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!