TreeView

[Hermione]

HI

I have 2 tables,
First Table locatisation: ID_Localisation (PrimaryKey), Name, Address
Second Table Infos_Loc: ID_Infos_Loc(PrimaryKey),ID_Localisation
(ForeighKey),Section,Name

I'd like to know if it's possible to view the data of both table in a
TreeView, instead of opening the form Localisation with a subform I want the
user to be able to visualize all data

This is my example:

Localisation: Walmart ; California (parent)
InfosLoc: Section:1; Name:Util
InfosLoc: Section:2; Name:Util1
InfosLoc: Section:1; Name:Util4
InfosLoc: Section:3; Name:Util1

Localisation: Zellers ; California (parent)
InfosLoc: Section:1; Name:Util
InfosLoc: Section:2; Name:Util1
InfosLoc: Section:1; Name:Util4
InfosLoc: Section:3; Name:Util1


Any help please

Thanks

 

[Albert D. Kallal]

You can in fact use the treeview control..but it takes a good deal of code.

Another nice possible solution is to use two sub-forms side by side (or a
listhbox). I have a screen shot here that might give you some ideas:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

In fact, I used the above screen in place of a treeview.