AnsweredAssumed Answered

Calculated Serial Number

Question asked by bleyden on Dec 11, 2017
Latest reply on Dec 11, 2017 by bleyden

I have a table "Families" with a serial number field "FamID" (6 digits).  When records are created in a portal on my "Families" layout, they are saved in my "Individuals" table and given an "IndID". 

 

2 questions:

How can I make the "IndID" an 8 digit number that has the FamID as the first 6 digits, and then a new serial for the final 2 digits?  For example, The Johnson FamID is 111111, and then John Johnson would be 11111101, Sue Johnson would be 11111102, etc etc.

 

In my Individuals form, how could I set it up so that if a new Individual record is created it also creates the FamID as well?  Right now I have it working great when I create a family and can find an individual that was created there, but I'm curious if there is a way to also incorporate the reverse.

 

Thanks!

Outcomes