AnsweredAssumed Answered

Question on Table Instances

Question asked by lobstah on Oct 30, 2017
Latest reply on Oct 31, 2017 by beverly

I hope I'm asking this question correctly, and I welcome any suggestions.  I am in the process of setting up my ER diagram.  I've reached a point where I'm not sure exactly the best way to construct a table(s).

 

There are 3 tables involved in this scenario

 

People

Insurance

Supplier

 

 

So here's the issue, which I will try to write out.   A person (people table) can have a single insurance company (insurance table).  They also can have a single supplier (supplier table).  The issue is that each supplier can accept multiple insurers.  I can't, however, link the insurance table to the supplier table because it's already linked to the people table.  I want to avoid having to create a table with the exact same information in it, but I'm not sure if that's possible.  Perhaps there's a workaround that I just don't know about?

 

Thank you!

Outcomes