Hope someone can help, I've sweated over this all day.
I have 3 tables, Demographics, Admissions and Attendances.
Patient's records are stored in Demographics (obvs) and each can have more than one Admission and numerous Attendances within those Admissions.
I'd like to be able to represent each Admission on a form with each of the associated Attendances documented in a subform at the bottom.
I thought this would be easy, but its just not happening :banghead:
Any help would be appreciated
I have 3 tables, Demographics, Admissions and Attendances.
Patient's records are stored in Demographics (obvs) and each can have more than one Admission and numerous Attendances within those Admissions.
I'd like to be able to represent each Admission on a form with each of the associated Attendances documented in a subform at the bottom.
I thought this would be easy, but its just not happening :banghead:
Any help would be appreciated