Lookup record before the current record
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 fie...
Forum Discussion
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
Thanks for your reply. I am looking at saved records where the record id was already generated. I also see the record ID -1 showing up correctly. But the values of that record are not there.