I'll try to make this short and easy to follow. I have a database with Table #1 that has a control number field and other fields. I have four other tables that also have a control number field and that is what is used for linking all together. In other words, the four tables individual link to the first table.
Now, in table one, each field in that table only has one entry for every one control number. The same thing goes for table #3. However, tables 2, 4, and 5 have multiple entries in their fields for a single control number.
Now what I've already done is created a report based on table #1. Every other table gets it's own subreport so that I get all the possible entries made against the control number in each table (For table 3 the subreport was not necessary but did it anyway).
Now this entire report (including subreports) needs to go into a another report as a subreport, hence, my problem (That rule against no subreports with a subreport). Thus, I'm trying to find a solution.
What I was able to do is to do a grouping based on the control number in table 1. I place all the fields for table 1 as a group header and then place table 2 in the details section. Those I was successful in populating all of table 1 (only one entry per field based on control number) and I was able to get table number 2 to post multiple entries per field based on the control number. However, I can't figure out how to go to table 4 and 5 to do the same thing without repeating the duplicate posting of table two again (I made a details section b, c, d and e.
Any thoughts on how to do this?
[sig][/sig]
Now, in table one, each field in that table only has one entry for every one control number. The same thing goes for table #3. However, tables 2, 4, and 5 have multiple entries in their fields for a single control number.
Now what I've already done is created a report based on table #1. Every other table gets it's own subreport so that I get all the possible entries made against the control number in each table (For table 3 the subreport was not necessary but did it anyway).
Now this entire report (including subreports) needs to go into a another report as a subreport, hence, my problem (That rule against no subreports with a subreport). Thus, I'm trying to find a solution.
What I was able to do is to do a grouping based on the control number in table 1. I place all the fields for table 1 as a group header and then place table 2 in the details section. Those I was successful in populating all of table 1 (only one entry per field based on control number) and I was able to get table number 2 to post multiple entries per field based on the control number. However, I can't figure out how to go to table 4 and 5 to do the same thing without repeating the duplicate posting of table two again (I made a details section b, c, d and e.
Any thoughts on how to do this?
[sig][/sig]