Treeview

[Jedit]

Anyone explain how you would display this query in a Treeview form.

SELECT tblPowderbatches.[BATCH#], tblPowdermix.[MI-Batch] AS MIBATCH
FROM tblPowderbatches INNER JOIN tblPowdermix ON tblPowderbatches.MECHT_ID =
tblPowdermix.[NPOW-ID];


What I would like to see, Batch# displayed as the initial node, once the
user has input a batch#, then a branch output for MIBATCH (Branch-1), MIBATCH
is then looked up in BATCH# & again the MIBATCH is output as a sub branch of
the initial branch (Branch-1) & so on etc…..
Parameter inputs on criteria are no good in this instance as critical Batch#
are filtered out.

Struggling like you wouldn’t believe on this task, sometimes you cant see
the woods for the trees, better to ask than keep going round in circles?

 

[Stefan Hoffmann]

hi,

Anyone explain how you would display this query in a Treeview form.
Struggling like you wouldn’t believe on this task, sometimes you cant see
the woods for the trees, better to ask than keep going round in circles?

http://support.microsoft.com/?kbid=209898 shows how to populate a treeview.


mfG
--> stefan <--