Forum Discussion
Solved
many to many relationship
does someone know a solution for this many to many relationship? Every column in the 2 tabels is many to many. I find no solution for this. I will also filter these 2 tabels together.
It might pay to keep company as a separate lookup table as you may have companies that can appear in multiple regions/countries.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeWhy not combine the Country and Region into a single table with two columns.
I assume every region belongs to a country.
Make sure the regions in your new lookup table is unqiue and create a relationship between Region and your other tables. Then you can slicer on country, or region in your new table and it will make more sense.
Phil_Seamark great!
Now i will also filter on company and a company occurs serveral times in a region and country
- Phil_Seamark
It might pay to keep company as a separate lookup table as you may have companies that can appear in multiple regions/countries.