Hi, I am constructing a database to control vehicles. In one of the tables I want to insert every week the odometer of every vehicle. Like this:
Field 1: ID Autonumber
Field 2: VehicleNumber (related to another table with all the vehicles)
Field 3: Date
Field 4: Odometer
When introducing a value in Field 4 (odometer value), I would like to check for the past records and see what was the last value in this field for the same VehicleNumber, and restrict the value to be higher than the last one.
Is this possible? Or do I need to look for another arrange?
Help appreciated...
Thanks