M-M relationship
Dears, for M-M relationship It's only work if we make a third joined table, Right ? Making two 1-M relationship between the two tables is wrong ? correct ? By saying wrong I mean it will be...
Forum Discussion
Hi Yasser,
If you are looking to be able to have records related so that many records could be related to many records yes you would need a 3rd many to many table to serve as the join to allow you to get the flexibility for many records from table a to be related to many records from table b. There are use cases people have where they relate two tables back to eachother but for a true many to many the joins table is important to give you the relationships you need.
------------------------------
Evan Martinez
------------------------------
If you are looking to be able to have records related so that many records could be related to many records yes you would need a 3rd many to many table to serve as the join to allow you to get the flexibility for many records from table a to be related to many records from table b. There are use cases people have where they relate two tables back to eachother but for a true many to many the joins table is important to give you the relationships you need.
------------------------------
Evan Martinez
------------------------------
