Index | date | starting Km (SK) | Closing Km (CK) | Total Km |
1 | ||||
2 | ||||
3 | ||||
4 | first Km (FK) | |||
5 | Last Km (LK) | |||
6 | Progressive Km (PK) |
<tbody>
</tbody>
As enumerated above from 1-3 (upto 50 in actual file) individual enters daily starting Km and ending km, total km automatically gets updated for that day (CK - SK).
First Km (FK) also gets updated, now the problem starts I want Last KM(LK) to automatically update as individual enter CK so that Progressive KM (PK) i.e. LK - FK gets updated accordingly.
How do I do it.