Hi Jeff,
I think you are over complicating this.
One employee has many detail records with numerical values.
Just make a summary to get the totals you want up to the Employee Record and it will be a total for each individual separate employee. Then you can look that up down to any other child table you want on the other relationships
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Mark, so I am going to make the summary table on the employee list table, correct?
This app is the redevelopment of an older app I am no longer using, and the employee table is the only table that pre-existed this project, so other than using it to supply employee data, never thought to include it as part of the numerical process.
Thanks again, you are always so helpful.
Jeff
