I have a fairly simple database, 5 tables, 1 master and 4 child tables, all related to the master by the same ID field. There are multiple records per child.
I have 4 subreports, one each for the child table in a master report. The subreports are "fed" from queries, based on the ID field. It runs fine EXCEPT that it requests the input of the the parameter (ID field) 4 times. I've checked the queries and there is no parameter (criteria) value, but in the Data Relationship window, all the child tables are linked to the master table correctly.
Any help?
Thanks in advance,
Tom
I have 4 subreports, one each for the child table in a master report. The subreports are "fed" from queries, based on the ID field. It runs fine EXCEPT that it requests the input of the the parameter (ID field) 4 times. I've checked the queries and there is no parameter (criteria) value, but in the Data Relationship window, all the child tables are linked to the master table correctly.
Any help?
Thanks in advance,
Tom