Yes, the view shows all records desired via a select statement for MO_Number = .vMO
The sub table view has only one common column (MO_Number) with the driving table. When I print the report, the sub report only shows one record. It is a correct record, but others should show as well. I checked that Dyanamic Height is clicked on all bands in the sub report. It seems like the master / slave table relationship is somehow set to a one to one instead of a one to many. However, I did not see where this could be set? Last build of 7.5 Any other thoughts? Thanks, -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: Lawrence Lustig <[email protected]> << I did not see in the FTE article how to narrow the selection in the subtable. I tried creating a single table view of the subtable that contained only the data I wanted to include, but the report only printed (1) record for some reason. >> This is the correct approach (or, at least, _a_ correct approach). Check to make sure that the data you want is really in the temporary view. -- Larry
