Filter by last date

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I need to keep a record of historic prices that my vendors give me, but only show the last update on the reports.  

Part Number            Price             Date Updated

AAA                          $10.00           2015/07/01     

AAA                          $9.50              2015/07/30

I need to keep a record of both prices, but only show the last price and use it for quotations.

Photo of Jaime


  • 0 Points

Posted 4 years ago

  • 0
  • 1
The "right" way to do this is to have a child table called Prices. One Part has Many Prices.

Then make a Summary field in that relationship of the Maximum Record ID of Prices.

Then make a new Reverse Relationship based on that field and look up the Price. It will be the latest Price.

I assume you have data now with Prices. You can to a table to table copy or export to excel and import into the Prices Table and map the Record ID of the Parent into the child Prices field [Related Part].