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
What is the reference field on the right side of the relationship?