Hello,
Our department produces and prints products on a monthly basis. There are about six phases that each product goes through before it is either completed or canceled. For discussion purposes I'll call them Phase1 - Phase6. In reality, they are referred to by name such as "in edit, in review, in reproductions, etc." Not all items need to go though all of the six phases of completion and they may have various scheduled arrival dates for each phase. A production can be stopped at any time and cancelled or completed early.
I would like to have a form that shows the order of the Phases with space for a corresponding Date when the new phase is reached. I would also like space for a "tickler date" for each phase. If a product has not reached the next date by the tickler date it should turn red or blink or at least show up on a report of products which are late reaching their next phases so the managers can learn why. If a product is cancelled or is completed before the scheduled arrival for the next phase; phase checking should be ignored.
My guess is that the table should be written similar to the following. Please correct me if I am wrong:
ItemName
Department
Phase1
Phase1-date
Phase2
Phase2-date
Phase3
Phase3-date
Phase4
Phase4-date
Phase5
Phase5-date
Phase6
Phase6-date
Completion-date
Cancelled-date
I also guess that the program will check the dates from from bottom-up and compare each date against the current date. It seems to me that the program will automatically ignore or skip any Phase date with no entry. This is the way that it will not that that a particular phase is not applicable to the current Item.
Thank is about as far and I know to go. Please help.
Start Free Trial
