Forum Discussion
Solved
Many 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 missi...
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.
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.