Billable Hours Report
We have a Work Order table to track services performed. Each work order can have up to 3 services. Each service can have 2 employees who work on it, so there can be up to 6 employee and employee hour...
Forum Discussion
It's the 6 relationships that will kill you for reporting.
My suggestion is to have a new table of employee work order assignments which will be a child of employees and a child of work orders. The employee time will be logged there. The kill those 6 relationships or phase them out if you already have data.
My suggestion is to have a new table of employee work order assignments which will be a child of employees and a child of work orders. The employee time will be logged there. The kill those 6 relationships or phase them out if you already have data.