Have a filtered group of records, want to update a field on ONLY the highest Record ID - possible?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a report that filters down records based on a product SKU. I then have a button that will update the Status field in all records within that report. 

My problem is that my company is now using the same product SKUs season over season, but I keep a record of each SKU in each season. I want the button to only update the most recent record. Is there a way to do this? 

My first thought was to make a formula field that assigned a numeric, increasing value to each season. I thought that there might be a way to only update the record with the highest value in that field. Or, I thought there might be a way to filter the report to only display items that have that product SKU and the highest season value. 

Any help is much appreciated here!!!
Photo of Adam

Adam

  • 730 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Adam

You can create a parent table with one record whose sole purpose is to summarize the max record ID# of the child table.

You'd have to make sure every child record has this parent's foreign key field as its relation to the parent.

In the relationships properties for these two tables, set a summary field up in the parent that summarizes the "Maximum" of the field [Record ID#].

This will give you what you're looking for in the way of establishing what the child table's max id# record is, and it will give you a start to build on the summary properties.

Hope this helps,