I have Main Qry with overall Customers data that is linked to a sub qry with detail information about the same Customer. The main qry is set up to be able to scroll through all my customers using the VCR buttons, but when I scroll through the Customers in the main qry nothing changes in my Sub qry. I have the two qry's linked by Customer # and in my filter I have <Customer number> = Main qry <customer Number>. The sub qry only brings back the data for the 1st customer in the main qry. How can I get the sub qry scroll with my main qry??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help with Cognos report with Sub Qry 1
- Thread starter B555
- Start date
-
1
- Thread starter
- #2
misscognos
Programmer
product?
if CRN or Cog 8, it doesn't seem like you are using a master detail relationship.. can you confirm? What is this "subquery" you refer to?
if CRN or Cog 8, it doesn't seem like you are using a master detail relationship.. can you confirm? What is this "subquery" you refer to?
- Status
Similar threads
- Locked
- Question
- Locked
- Question