I have a data model requirement where I require to build "many to many" relationship between two tables. just wondering if anyone can share some example on how to construct this:
The current two table are as below where I have a key Plink to link them together and I have supplier name in the first table with measure in the second table. I want to introduce a third table where I will store four dimension of data: Supplier Name, Month, Year and Number of products. the aim is that in my front end I will be able to tell for each period, the sales for each product and with the number of product sold in that month, please be ware I won't be able to insert the information into the Sales table as the below is just a simplification of my current data model.
current report that can be built from the current model and I want to build additional one field to show the number of products sold in the month.