I have 2 tables. One called "Jobs" and the other one "Hours". "Jobs" has the amount of time alloted for that specific job. "Hours" has a number of entries per day that go toward different jobs.

My question is, how to I create a field on the "Jobs" table that subtracts the total of hours completed from the "Hours" table based on each job?

I've created a report that divides up and sums the hours based on the job number from the "Hours" table but don't know how to use that to subtract from the total allotted on the "Jobs" table.

Edited September 1, 201015 yr by Guest

Nevermind...I figured it out.

I have a sum total field in my Hours that totals them all up. In my Job field I added that sum total field with a relationship between the two tables. It only gives me back the total of the job number I am looking at.

FMP is smart!