Can a Summary Field Identify Oldest or Newest Record ID.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I'm working on an inventory/order process that takes into account FIFO - so i'm trying to ensure the oldest inventory records are added to an order automatically.  If I could carry over the oldest record ID from the inventory table, I can make it work.

I thought about trying to create a summary field that will show the oldest Record ID. Maybe oldest is the wrong word to use here, 'smallest number' might be more accurate since Record ID's only grow larger.  Can a summary field do this?  I attempted to create one that looked for the "minimum" Record ID, but it didn't return anything. 
Photo of Ringoparr

Ringoparr

  • 854 Points 500 badge 2x thumb
  • Unsure

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
The 'Minimum' record ID# is what you are looking for.  That odd that its not showing anything. 

Do you add additional conditions to the summary field?
Photo of Ringoparr

Ringoparr

  • 854 Points 500 badge 2x thumb
Thanks for letting me know that i'm on the right track.  I filtered the summary based off of another summary field that basically states if the Inventory was already issued.  I'll mess around with the conditions to see if i can get it to work.