I am trying to figure out how to use a tree view to browse through related records in three seperate tables.
the table are related in the following manner
tblArea
AreaID
AreaName
tblRow
RowID
AreaID
RowName
tblPlot
plotID
RowID
PlotName
There is other associated information in the tables but the fields I list ar ethe important ones.
What I am trying to do is build a tree view of the information in those tables so that a person could select any records from any of the tables by expanding through the relationship...
What I mean is that they could expand area 1 to view the associated rows and expand a row to view the associated plots.
Additionally I need to have the functionality to select any item (area) (row) (Plot) and by clicking on a button transfer that information into a list view.
That list view is essentially used to reference the information from which an eventual record will be built.
The way it would work is a user could conceivably select any number of locations from within the structure of the tree and transfer them to a listview. Some further associated information is added into other tables and eventually a record is built compiling all of the neccessary data into a new record.
The problem is I am having a problem figureing out the best way to allow users to browse through available "locations" and select those location for the purpose of recording an event that effects those locations.
The tree view seems to be the best solution for what I want but I frankly have NO IDEA how to work with this control. I have no idea how to first of all associate it with the tables and fields to correctly display the information and then following that up with how to transfer selected items into a list view that is used essentially as a temporary storage location until the record can be built utilizing that information.
If anyone would car to help me with this it would be greatly appreciated. I have the active x demo utilizing tree views but I cant for the life of me figure out how it decides what data it uses for its values
the table are related in the following manner
tblArea
AreaID
AreaName
tblRow
RowID
AreaID
RowName
tblPlot
plotID
RowID
PlotName
There is other associated information in the tables but the fields I list ar ethe important ones.
What I am trying to do is build a tree view of the information in those tables so that a person could select any records from any of the tables by expanding through the relationship...
What I mean is that they could expand area 1 to view the associated rows and expand a row to view the associated plots.
Additionally I need to have the functionality to select any item (area) (row) (Plot) and by clicking on a button transfer that information into a list view.
That list view is essentially used to reference the information from which an eventual record will be built.
The way it would work is a user could conceivably select any number of locations from within the structure of the tree and transfer them to a listview. Some further associated information is added into other tables and eventually a record is built compiling all of the neccessary data into a new record.
The problem is I am having a problem figureing out the best way to allow users to browse through available "locations" and select those location for the purpose of recording an event that effects those locations.
The tree view seems to be the best solution for what I want but I frankly have NO IDEA how to work with this control. I have no idea how to first of all associate it with the tables and fields to correctly display the information and then following that up with how to transfer selected items into a list view that is used essentially as a temporary storage location until the record can be built utilizing that information.
If anyone would car to help me with this it would be greatly appreciated. I have the active x demo utilizing tree views but I cant for the life of me figure out how it decides what data it uses for its values
