Topic: Rolling Fields - How to achieve?
Greeting,
As I push thru my first MVD project I am again trying to figure out how to implement something or whether there might be better ways. Using MVD v6.5 with SQLite DB.
I have the following situation. I have two (2) sets of 5 fields that are a status and date for that status. The fields are Current, Prev-1, Prev-2, Prev-3 & Prev-4. When a new event occurs I want to put it into the Current fields, but first must roll Prev-3 into Prev-4, Prev-2 into Prev-3 ... and finally the Current into Prev-1 before installing the new Current Values.
These fields are on a form in a single row presently. How can I effect the rolling of the values?
Regards,
Keith