Calculating Totals for Specific Fields
I am new to Filemaker, and am trying to figure out if it is possible to calculate a total for specific fields in a table.
I have a table that keeps track of when employees have left for vacation and when they come back (the total would calculate how many days of vacation they have used up). This table would have multiple records per employee, and I want to know if I can calculate a total for a specific employee (and then use this in a formula for a related table).
If somebody could provide some advice, that would be greatly appreciated.