How to create a new database for reports by filter?
Im trying to create a new database that will allow me to create sales report each month.
I have 1 table with my product id and i would like to create another table with the product id's and the amount they sold each month(updated each month).
Now what i want to do is that i would be able to create a report from these 2 tables that the 1'st table will be filtered by the product id's in the second tables so finally i can see all the product id's that made selling and the amount of each one...
Am i designing the structure right or is there a better way doing this?