Generic Notes Table - Multiple relationship paths between two tables
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?