G
Guest
I need a little help creating a particular default value if this is possible
Lets say I have several vehicles with different numbers attached to them,
23, 43, 504, etc.
43 already has 3 entries along with the other vehicles (each on a separate
record).
In these entries there is a field for the "Last" kilometres readout, and a
field for present kilometres.
Assume I'm making another entry for 43 for the following scenario. Is it
possible for me to create the default value for "Last" kilometres based on
the Present kilometres from the last entry for 43 regardless of its position
in the recordset?
Ideally, it would be nice to be able to do this for all entries.
Lets say I have several vehicles with different numbers attached to them,
23, 43, 504, etc.
43 already has 3 entries along with the other vehicles (each on a separate
record).
In these entries there is a field for the "Last" kilometres readout, and a
field for present kilometres.
Assume I'm making another entry for 43 for the following scenario. Is it
possible for me to create the default value for "Last" kilometres based on
the Present kilometres from the last entry for 43 regardless of its position
in the recordset?
Ideally, it would be nice to be able to do this for all entries.