Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Using values from the previous record

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).

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.