Self Referential Many-to-Many Relationship?

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

I was able to get close, but when I view a company, the contacts only show it’s self instead of the individual contacts.

When I view a contact, it is correctly showing the companies


Hi,

Would you mind sending a support ticket via “Need Help” and grant Ragic Support access to your database so that we could have a better understanding of your design and maybe give you some suggestion?