Hello -- I'm new to Filemaker and I'm trying to build a payroll database.
If you aren't an accountant, you may want to consult one familiar with payroll and your location's tax laws to make sure that your final design doesn't create problems for you.
To get your totals, you need a relationship that matches to the payroll records for a specific employee and for a specific year:
Employees::__pkEmployeeID = Payroll::_fkEmployeeID AND
Employees::cThisYear = Payroll::cYear
cThisYear would be an unstored calculation field with Number specified as the return type: Year ( Get ( CurrentDate ) )
cYear would be similar: Year ( PayrollDate )
Then a calculation field defined in Employees: Sum ( Payroll::Field ) will compute the YTD total or you can refer to a summary field defined in Payroll.For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained