Forum Discussion

SamKrausz's avatar
SamKrausz
Qrew Cadet
8 years ago

Looking for a report of all items which we did ordered for the first time during last week

I have a Master table with a lot of products, every record is a new product, we are adding a lot of products each week into this table. Then we have another Details table with all the orders we did...
App builders
Relationships
reports and charts
KingslySamuel1's avatar
KingslySamuel1
Qrew Assistant Captain
8 years ago
You have to bring the relevant fields from one table to the other table as "lookup" fields (in the relationship) and then create a report to show all the details needed by using the filtering option. And, I hope in one of your tables you save information about the "date of each order".