I am setting up my Filemaker 17 Database and have a question about the best way to set up one of my tables.
So I would like to have a general "People Contacts" table, however within those I actually have two different types of people contacts "A" and "B". I want "A" and "B" (or a versions of the combined "People Contacts" table) to feature in two different places in my relationship diagram, the effect of which is that "A" is the Grandfather table of "B". How would you advise that I do that?
Many thanks in advance for your help!