8 Replies Latest reply on Oct 17, 2014 12:17 PM by rwforce

    How do you look up a value from a previous record for a specific field?

    rwforce

      I have a database used for tracking moving scenery in Broadway shows. The database lists cue number, axis number, move speed, and target postions (among other fields). Each move is entered as a new record, then group and sorted in a report by cue number. I want to be able to calculate the time of the move based on distance and speed. In order to do this I also have to enter the start positon. I would like to be able to auto-enter the start position based on the last move for that axis. This may be the same cue or a past cue, but in any case the prior record for that axis. Does anyone nkow how to do this? Thanks.