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
Unfortunately, I don't think I provided enough information. There is a parent table Locations that has a child table Services. Each Location can have many Services. The Work Order table is a child of Services. Each Service can have many Work Orders.The Work Order table is also a child of the Employees table. Each Employee can have many Work Orders. In order to accomodate the 6 potential fields I created 6 relationships (is there a better way?). Therefore, in order to calculate Employee hours, the only way I can figure out how to do that is to run 6 different reports (1 per field/relationship on the Work Order). That is my dilemma. Is there a better way for me to set up the Employee-Work Order relationship(s)? Or is there a way to add the 6 fields together for reporting?
