i'm developing an application that tracked documents using ms access as my front end and mysql as my back end. i have a hard time in the routing process. here's the process : on initial/first route - the user inputs an entry on the date received field, a value of "received" will be posted on the routing status field, and when the date released field has been filled up, routing status value will be "in transit to". on 2nd/succeeding route - when date received field has been field up by the destination office, routing status for the current record is "received" but for the previous record it must be "released"
fields involve are :
date and time stamp - system generated
office - receiving/destination office
routing status - received, in transit to, released
any help would be highly appreciated. many thanks.