[Return to contents]
Last updated: 17 Dec 1997
There are a couple of ways of doing this depending on what you are trying to achieve.
One method is to go to the 'previous record', set a variable field/s to the required value/s, and then go back to your original record.
A more complex method is to use an alias of the database to access both the current and previous forms at the same time, using joining fields that a set one record apart using macros. I.e. if you are joining by a field Id, then create a field PreviousID, set its value to Id - 1 using a macro, and use PreviousId to join to the alias. This solution only works though if Id is sequential with no omissions (which is unlikely).