Forum Discussion

RyanParr's avatar
RyanParr
Qrew Assistant Captain
8 years ago

Can a Summary Field Identify Oldest or Newest Record ID.

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. 
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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?
  • RyanParr's avatar
    RyanParr
    Qrew Assistant Captain
    8 years ago
    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.