AnsweredAssumed Answered

How to create a new database for reports by filter?

Question asked by NimrodMargalit on Jan 16, 2011
Latest reply on Jan 21, 2011 by philmodjunk

Title

How to create a new database for reports by filter?

Post

Hi.
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?

Thanks 

Outcomes