I want to make an app for church membership with many families in it. Families are grouped by location. And I want to access the family information by clicking on the household leader. The family information includes name, birthdate, phone, job and so on. Can someone help me with this?
Have you checked our sample apps if you could find a suitable for your case?
I would setup one table for every person (including name, birth,phone,job,etc). Then setup a second table for each family (including family name, location, family head, etc). Then have a virtual column in each family entity that is a list of refs that point to each family members.