Sync Subform Data with Main Form (1 Viewer)

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 ?

Have you linked the main form and the subform using "Link Master Fields" and "Link Child Fields"?

I neglected to say that I have a Main form/Subform/Subform situation.
Subform 1 is linked to main form and Subform 2 is linked to Subform 1

I believe that I have resolved the issue but will post back if not.
Subform 2 uses a Fake key to link to Subform 1.
Subform 1 is a Single form.

I have to test a little more and will post back.

Thanks,

Turns out it was a Calculated expression(s) getting in the way.