Subreport field link

[Scott]

I have a report that uses a query to return records from two tables based on
a record ID field. The related field in each table is called donor, so the
field list identifies the related fields as MainTable.donor and
NameTable.donor. I then created a group (with a header) that is based on the
MainTable.donor field. In the header I put the MainTable.donor field and the
name associated with the donor ID. At this point the report runs fine. I
then add a subreport that lists data (gift info) from a third table that also
has a donor field that serves as the child field link. The master field link
is MainTable.donor. When I try to run the report the report asks me to enter
the parameter for MainTable (not the MainTable.donor). Since the
MainTable.donor and NameTable.donor fields are identical, tried using the
NameTable.donor field as the master link, and I get the parameter request for
NameTable. Any suggestions?

 

[Duane Hookom]

Your main report's record source should include only one Donor field. You
shouldn't have MainTable.Donor and NameTable.Donor since these should be the
same value.
The same should be true for any report.