cheekybuddha
AWF VIP
- Local time
- Today, 15:14
- Joined
- Jul 21, 2014
- Messages
- 2,280
You don't need the WIP field in table WorkRequests_tbl at all. You are just storing redundant calculated data.
In table EngineerWO_tbl you have fields:
EngStartTimeDate
EngEndTimeDate
EngDateStart
EngDateEnd
I'm not sure of the difference between these different start and end dates/times, but they should indicate whether the related WorkRequest is:
Not yet started:
WIP:
Completed:
In table EngineerWO_tbl you have fields:
EngStartTimeDate
EngEndTimeDate
EngDateStart
EngDateEnd
I'm not sure of the difference between these different start and end dates/times, but they should indicate whether the related WorkRequest is:
Not yet started:
EngDateStart IS NULL
WIP:
EngDateStart IS NOT NULL AND EngDateEnd IS NULL
Completed:
EngDateEnd IS NOT NULL