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!

Store array/query in query cell

Status
Not open for further replies.

nohandlesleft254

IS-IT--Management
Apr 19, 2006
58
GB
Hi,

Can anyone tell me how to get to an array or a query stored within a query cell?

Im looping through the main query and want to be able to loop through the stored queries on each line...CFDump shows the array of the query inside the cell, but i cant workout how to replicate this output.

Thanks
 
Sort of - i want to show something like below

Item BU40 - Parts BB100 Available
BB350 Not Available
AB126 Available

Item BU50 - Parts BB110 Available
BB360 Not Available
AB127 Available

So i have a query 'Items' and in cell 'Parts' i have saved another query relevant to that item called 'ItemParts' - i just cant work out how to reference the query in the 'Parts' cell.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top