treeview from Access
Posted on 2005-04-29
This is a challanging one. I am wandering if it's possible to somehow set up a treeview in such a way that it gets node values from access tables. Would it be possible to use the relational database concept? Here is the problem.
I have two tables , tab1 and tab2. tab1 has 3 records representing processes a,b,c with one field holding these names. like
Tab2 has 9 records representing 9 subprocesses - a1,a2,a3 for a , b1,b2,b3 for b, and c1,c2,c3 for c.
tab1 has one to many relationship with tab2 thru field "process".
The question is, is there a neat way of using that relashinship and the tables to show on a treeview how the processes and subprocesses are related .