I need to rethink Master/Detail report

[wgma]

I have created a report that has a header (based on qryHeader) and a subreport (based on qryDetail).

I think that my problem is that the two queries are not related because the subreport is not showing up so I assume that it is not being initialized.

I need to create a master/detail report that will give me the header information once and the detail information multiple times.

I am assuming, and I am probably wrong, that I need to have two separate queries just to populate the header with one record and the detail with multiple records.

Can someone please explain to me how to do all of this in Access 2007?

Thanks.

 

[wgma]

I have looked at the Master and Child links and tried to set them based on the existing fields in the queries.

Both queries have a field that is the Bill Of Lading number. They are named differently but the value is the same. When I try to set the link I get a message that tells me that I must insert record IDs into the queries in order to set the links.

Shouldn't I be able to do this with the Bill Of Lading number?

 

[wgma]

I got the report to work however, I am having problems with the subreport format.

First off, I am only getting one record per page. I should be getting at least 2. I have tried to adjust the margins but to no avail.

Second, I can not see the column headers. I placed them in the page header. Should I place them in the report header?

Thanks