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 placed from our vendors
This 2 tables are connected with a regular Table to Table relationship
Now, we need a report of produces which was order for the
first time last week
We want to know all products which was order for the
first time ever, during
last week
How can this be done?
Thanks in advance for your help