I am a bit stuck in my data model. For a customer of mine I am trying to calculate the labour costs per week and per month based on hours worked and the hourly wage of an employer.
Attached is a part of the data model.
I have a master calendar that is linked to a LINK tabel containing department name (location of a store) & date, this LINK table is linked to several tables. Among other things, the Shifts table (containing for every employee the shifts worked, start time and end time, employee name etc.). This shifts table is linked to the employees table, which is again linked to the salaries table. The salaries table contains for every employee the wage in a certain period, again with start date and end date.
I am not sure how to continue, I often use IntervalMatch() for such things and have a direct link with the calender. But I do not know how to combine all the multiple tables with each other.
