I have two tables that I am dealing with. One table includes all of my employees and all of their jobs that they have been placed into (we can call this table "Employees"). The other table lists the locations for each job, and how much man power I have in that particular location, based on the number of employees (we can call this table "Locations"). Because the number of employees fluctuates on a regular basis due to changing contracts, I would like to directly link the number of employees (based on job type) into the various locations.
So are you looking to have an embedded Summary report of the Employee Assignments on each Location record? Are you looking to summarize, for example the # of Employee Days or hours by Job type on the Location record?
Each of the totals for these general buckets breaks down further... by location, as I mentioned earlier. This information is all in the first table I described.
There is another table, for which I am trying to determine the labor capacity for each particular location, broken down by those 5 general buckets. Ideally, I would like to have a formula field that uses the total # of employees per bucket (per location) to calcuate various totals for 'hours available', etc, etc.
I also want to compare current capacity to the current demand for each location to determine the surplus/defecit for each general job bucket.