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".
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.