Help with getting a total
I have a field in several different records I want to get a total for. I have Timecard::TotalHours (One person per timecard (EmployeeIdfk) ) and I want all of the hours for one person to be in one total (EmployeeCard::TotalHoursWorked) My thoughts right now are to do a search in the timecard table for everyone with that id and add up all the hours worked but I dont know how to do this. Any tips tricks or anything really that would help I would greatly appreciate it.
Thanks - Austin