Can anyone please help me with the following scenario. I have been using PHPRunner for simple things, but this seems to be a little more complex..
Scnario
Table 1 ( Master ) Employee
EmpID, Name, Hours_Accrued, Hours_Used, Hours_Remaining
Table 2 ( Detail ) Time_Off
TimeID, EmpID, Name, Date_Requested, Hours, Approved
I have used the TOTAL to total the hours on the list page.
Is there a way to have the "Hours_Used" field Display the Total Hours from the "Hours" field in Time_Off Table