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 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 
  
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".
  • SamKrausz's avatar
    SamKrausz
    Qrew Cadet
    8 years ago
    I am looking to get when the item was first time ordered & only if it was ordered during last week then it should come up

    How can this be done?
  • MichaelBarrow's avatar
    MichaelBarrow
    Qrew Cadet
    8 years ago
    Create a Summary field in the Products table in the relationship and call it [Earliest Order Date] and make it the Minimum Date from the Details table. Then, you can use this date to filter in your report.
  • MichelleMichell's avatar
    MichelleMichell
    Qrew Cadet
    8 years ago
    Is a new product added to the table in the same week it is first ordered? If so, you could make a summary report based off of the record's Date Created instead of creating a new field.