AnsweredAssumed Answered

Field value greater than previous record

Question asked by JohhnyHilly on Jan 20, 2013
Latest reply on Jan 21, 2013 by philmodjunk

Title

Field value greater than previous record

Post

     I have a layout with a portal in. In this portal I have a drop down list to select a certain piece of equipment. I then enter a field value for this equipment, total running hours. Every week I'll be creating a new record and entering the new total running hours for this equipment, so how do I ensure that the most recent value entered will be greater than from the previous record. The records are linked by a vessel name and each record has an ID number associated with it.

     Also I need to take into account the fact the first entry/record will not have a previous record to compare to.

     I'm not sure how to go about this. Can anyone help me with this? Thanks.

Outcomes