- Change Log
Course Status (Main Record: Course ID)
Projects (Major Projects)
- Major Project Pending
- Major Project in Progress
- Major Project Completed
Change Log (Minor Changes)
- Minor Change Pending
- Minor Change in Progress
- Minor Change Complete
All projects and changes have launch dates. A project or change can be Complete, but will launch on a certain date (the dates are in a connected Calendar table)I would like all three to relate to each other, but in the following manner:
- All Courses have the default value of LIVE unless we move to ARCHIVED
- If a Major Project or Minor Change is started for a course, the user changes the Status to Pending or In Progress. The Status then shows up in the main Course table so if the main record is accessed, it shows the course being worked on in a project or minor change.
- When the Major Project or Minor Change is marked as Complete, the Status in the main course table will automatically change to LIVE when the Course Copy date occurs.