Is it possible to have the following structure???
Properties Table has an Owner field that links to a contacts table.
Contacts can either be People or Companies
If it’s a company, I want to display a subtable of People in that company and their relationship to that company (like a sql join table where I have company (points to a contact), name (points to a contact), relationship (select field))
And when viewing a People contact, I want to display all companies they belong to