Assumptions:
-Multiple Jobs can be peformed in one day (queiries must be able to display all jobs performed on a selected day)
-Multiple Delays will occur within each job.
Crucial Form Fields:
-Date, ProductionStartTime, ProductionEndTime
Crucial SubForm Fields (To Enter Production Delays):
-DelayStartTime, DelayEndTime, DelayReason
Goals:
-Calculate the Production Time by subtracting ProductionStartTime from ProductionEndTime.
-Calculate Delay Minutes by subtracting DelayStartTime from DelayEndTime
**Key Problem** Ex. A Job may begin on Oct 1 at 5AM and end on Oct 2 at 1AM
-Multiple Jobs can be peformed in one day (queiries must be able to display all jobs performed on a selected day)
-Multiple Delays will occur within each job.
Crucial Form Fields:
-Date, ProductionStartTime, ProductionEndTime
Crucial SubForm Fields (To Enter Production Delays):
-DelayStartTime, DelayEndTime, DelayReason
Goals:
-Calculate the Production Time by subtracting ProductionStartTime from ProductionEndTime.
-Calculate Delay Minutes by subtracting DelayStartTime from DelayEndTime
**Key Problem** Ex. A Job may begin on Oct 1 at 5AM and end on Oct 2 at 1AM