AnsweredAssumed Answered

Table Relationship

Question asked by Phil_1 on Jun 21, 2018
Latest reply on Jun 21, 2018 by philmodjunk

I'm on FMP Adv. 16 table relationship question.


I'm putting together a database of companies and their owners:


Currently I have split "Individuals" and "Companies" into their own tables.


I created a join table called "Ownership" that gets the ID_Match field from the "Companies Table" and the "Individuals Table" respectively.  (I am assuming this is a PK and not a FK because I'm not allowing the "Ownership Table" to create records in either the "Companies" or "Individuals" tables. But please correct me if my understanding is wrong.)  This works fine to create a relationship between Individuals and Companies.


My problem is how do I set up the relationship so Companies can own Companies and have an associated percent of ownership?


Thanks for helping