Skip to main content
Question

Lookup record before the current record

  • June 19, 2018
  • 0 replies
  • 94 views
I needed to lookup a values of a record before the record I am currently on.

I created a formula [Record ID#]-1

I created a relationship pointing to the same table with proxy of this formula field

This should point to the record before the current record.

I added the fields I want to pull from the previous record but the data does not show up. When I look at the previous record it's there but its not pulling the values for some reason.

Am I doing anything wrong?

Thanks

    Forum|alt.badge.img+5
    • DrewVoge
    • Registered
    • June 19, 2018
    the record ID of any new record is not created until the record is saved for the first time.  so, you probably want the self-relationship to include a summary field which is 'MAX - Record ID', so that you know the largest Record ID# CURRENTLY in existence
    Terms & ConditionsAccessibility statement