Sync Subform Data with Main Form

I have tblEmployees for employee info

tblEmployeeAbsences for employee absences

tblVacation for employee vacation info



While entering the employees hours I want an adjacent subform to show the matching employees absence and vacation days taken if any.



My approach was to use a Cartesian qry for the record source for the subform and link it with a fake key from the main form.



It does not of course show the correct data.



Ideas ?

Sync Subform Data with Main Form