Hello, I am designing a database in Filemaker for my church. We are initially going to use it to track members and guests. I am creating a layout to view all the members right now. I would like to have a section on the layout that shows who the family members of an indivdual are. It would be nice to be able to click on the family member and view the layout for that person. I have address information and would like Filemaker to assume that if people are living at the same address, they are family members.
How could I do this? Should I create a seperate "family" table and use a portal?