AnsweredAssumed Answered

Generic Notes Table - Multiple relationship paths between two tables

Question asked by joeworkman on May 1, 2009
Latest reply on May 1, 2009 by philmodjunk

Title

Generic Notes Table - Multiple relationship paths between two tables

Post

 I am trying to create a generic notes table to contain notes for various elements in my database. The notes could be associated to a person on the "people" table or to a deal on the "deals" table. However, there is a relationship between people & deals already. Therefore when I try to link the People and Deals table to the notes table, I get an error saying that there are more then one relationship path. 

 

While this is technically true, the purpose of my notes table it just to assign a note to either a deal or a person. How can I do this? Do I have to have two separate notes tables?

 

Cheers

Joe 

Outcomes