Please pardon me first: I know this forum might not be the most fitted one but I also know this forum attracts most users so I decided to post my question here.
I have a new database which contains a table called workflow. The table has 10 items and basically each one represents a status.
The values are:
Draft, Saved, Submitted, Returned, LARReviewed, LARSignedOff, SCRReviewed, SCRSignedOff, ...
For each record created in the project, different workflow will be assigned to it.
I almost finished my preliminary front-end and back-end design and just realized a disaster during the final testing:
The system allows any record has more than one status in (LARReviewed, LARSignedOff, SCRReviewed, SCRSignedOff)!!! and my main table has only one int field for the workflow. So it seems impossible to take multiple workflow for one single int field.
I want to hear your advise on this.
Thank you in advance, any suggestion is welcomed and appreciated.