I am trying to improve a database so that FileMaker identifies "Family Type" for each person in each family in our database.
The database looks like this:
|2||1||Genetic Disorder A|
|5||2||Genetic Disorder B|
|8||3||Genetic Disorder C|
In English, I want my FileMaker calculation to basically do:
"For each group of records with the same family_ID value, output the Genetic Disorder type (A,B, C, etc) if there is one; otherwise, output "Typical Family"
I was thinking of doing a "for loop" strategy but I wanted to see if anyone in the community had a better idea or any tips - I am not sure how to code this!
Thanks in advance!