Many to Many Relationship

[aishak12]

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? 

[v-jingzhang · Accepted solution]

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.

[PaulDBrown]

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.