ASP.NET Form / SQL Logic
Posted on 2011-09-09
I'm not sure if this is the correct forum for this question. I'm not necessarily looking for code, but just help with the logic on how I can get something to work .......
I'm creating an ASP.NET (vb) application that is going to be a car mileage claim form. The user inputs car journeys indicating their start mileage and end mileage, the form is totalled and once a month submitted to the payroll section to pay so much per mile.
When the user enters a new journey, the start mileage of the new journey must be equal to or greater than the end mileage of the last journey they input. This in theory works fine – UNTIL, the user forgets to put one day’s journey in, and then the new journeys start and end mileage are in-between another journey.