I have a small project management solution and to create a cost report for the projets I need to be able to get the actif payrate at the moment the work was performed. I have a table with the employee ID, payrate and effectif start and end dates for the payrate. On the timesheet details, I have the employee ID and the worked date. In SQL this would be a simple select query with Select payrate from Payrates join Timesheetdetails on employeeid where dateworked >= EffectifStartDate and dateworked <= EffectifEndDate
How do I do this in FileMaker?