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 can't picture how that could work.maybe there is a solution if there was a table of all the record ID's, but I have not thought this though.
