Forum Discussion
CourtneyRapp
7 years agoQrew Cadet
Hi Evan,
Yes there are various Project names and some records will match based on the project name. Basically this is the structure of the whole table:
Project Name Hours Total
Project A 50 100
Project A 50 100
Project B 25 25
So the current relationship in place on this table is with the Project Name table, but as records are added to this one, ideally the total would reflect the sum of hours per project up to that most recent entry.
Ultimately I would be using this Total field in another equation to display budgeted time remaining for a project. Sorry if I'm not explaining/understanding everything 100%!
Yes there are various Project names and some records will match based on the project name. Basically this is the structure of the whole table:
Project Name Hours Total
Project A 50 100
Project A 50 100
Project B 25 25
So the current relationship in place on this table is with the Project Name table, but as records are added to this one, ideally the total would reflect the sum of hours per project up to that most recent entry.
Ultimately I would be using this Total field in another equation to display budgeted time remaining for a project. Sorry if I'm not explaining/understanding everything 100%!