I'm designing a workflow dbase tool and need to add a status column to the table. Question is how would I populate it with about 10 different static status types as well as timestamp and keep a history of the timestamp? I'm building a workflow tool to track steps in project mgmt process. I'm tracking off of order numbers and users and will track from start till completion of the job and keep a history of time in each status and total time overall. I'll figure out the frontend after I get the backend right.
Thanks for any help as it's greatly appreciated, just jumping into the database world finally after avoiding it for the last 7 years in MIS.