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
i'd point out that your formula field that is currently [recordID]-1, would change to something like if(isnull([recordID#),[MAX-Record ID],[RecordID]-1)