Discussions

Expand all | Collapse all

Can a Summary Field Identify Oldest or Newest Record ID.

  • 1.  Can a Summary Field Identify Oldest or Newest Record ID.

    Posted 04-27-2017 15:12
    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. 


  • 2.  RE: Can a Summary Field Identify Oldest or Newest Record ID.

    Top
    Contributor
    Posted 04-27-2017 15:17
    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?


  • 3.  RE: Can a Summary Field Identify Oldest or Newest Record ID.

    Posted 04-27-2017 15:53
    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.