Forum Discussion
Helper IVMany to Many Relationship
All,
I have this relationship between two tables. I have a question
If the top table does not have a record in the bottom table, what will happen?
I do not want any data removed or missing. Will it just populate a blank row for table 2 if nothing matches the value?
Hi aishak12
Please refer to the solution in this thread: Join 2 different tables without removing unique codes
I believe it is exactly what you want.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
PaulDBrownCommunity Champion
Best practices recommend avoiding many-to-many relationships. Create a dimension table for the common field and create a one-to-many relationship between this dimension table and both tables.
v-jingzhangCommunity Support
Hi aishak12
Please refer to the solution in this thread: Join 2 different tables without removing unique codes
I believe it is exactly what you want.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.