Help with Hierarchy/Tree ownership structure
I need help with a relationship structure.
I have a list of individuals and companies and investments. I need to form some sort of ownership tree or structure to determine who owns these companies and investments. The problems is that companies can be owned by individuals outright and companies can be owned by other companies. This company owning other companies can extend 4 or more layers deep.
Here is sort of a plain English example. Lets say you own 100 shares of Apple. You own 50% of company A which also owns 100 shares of Apple. Company A owns 25% of company B, who owns another 100 shares of apple.
In reality you own 162.5 shares of apple (100+ 50 (.5*100) +12.5 (100 * .25 * .50). Company A owns 125 shares of Apple. Etc.
How can I set this up in Filemaker. Please keep in mind that a company or person can come at any level of ownership. I feel like there is some sort of self join needed but I am not sure.