I need to produce a composite report for my database.  The database contains student information.

The first table contains the "front page" information, consisting: Name, DOB, Class, Residential House.

Then there are other tables all with a lookup selection box in each pointing to Name+DOB from this front page. 

These tables contain:

Home Information

Family Contact Information

Emergency Medical Information

Daily Requirements

etc etc

I need to produce a final report using the majority of the fields across all the tables as content.  

I have tried to create a hidden form, based on the front page table, but then containing sub-forms for each of the tables above.  I will then use this "super" form to run a report against.

However, despite not having any filters on the data, when I create this form and then a report from the form, all I get is "No data available".

I am completely puzzled what I could be doing wrong to be honest!  As far as I am aware, these other tables should be linked to the front page table by this lookup field, yet I am struggling to pull information from these tables related to the student.  Could it be because I used a composite lookup - ie Full Name+DOB as the lookup?

Any thoughts what I need to check?

I bow to your greater knowledge!

Thanks very much