Hi,
I have attached a dummy db to understand how to perform this on my real DB.
I have 4 tables:
1.product list
2.structure of the business (Buiness & business entities)
3.structure of the region
What I have been trying looks quite simple ... I think! Although I have tried every possible relationship and can't make it work!
I want to combine them together, so I want each line of table All lines of 2&3 to be matched to table 1. As per "wanted structure" in the dummyDB.
Basically my product list is global and I will need through a form to split my heads per business and country.
Thank you for your help!!
C.