Forum Discussion
Many to Many Relationship
Hello, please help in such situation: I have 3 tables without unique prospect account(simple example). I need a relationship with Event-Contracts and Event-Sales. The main idea to choose event an...
Hi Eugene-CHN,
Two one-many relationships and a median table compose a many-mant relationship. You'd better create a new table which contain [Prospect] column between the three tables and make relationship between the three table and the new median table.
Keep in mind, the values in the column of new median table should be unique.
Hope it's helpful to you.
Jimmy Tao