AnsweredAssumed Answered

More than instances of one foreign key

Question asked by cillion on May 19, 2016
Latest reply on May 19, 2016 by beverly

Hi.

Lets say that we have the database with tables PEOPLE, COMPANY, PHONE and EMAIL. Both PEOPLE and COMPANY could possibly have an email and phone. Now I choose to have fk_email and fk_phone in both PEOPLE and COMPANY, and this results in this error:

 

2016-05-19_10-23-33.jpg

 

How would you guys set up this relationship?

 

Thanks for all inputs

Outcomes