C
Clddleopard
Hi! I have the following SQL:
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));
It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby
I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby
But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?
Thanks!
SELECT [Animal Records].ID AS RecordsID, [Animal Records].Date, [Animal
Records].KI, [Animal Records].[Animal Name]
FROM StaffTraining RIGHT JOIN [Animal Records] ON (StaffTraining.Animal =
[Animal Records].[Animal Name]) AND (StaffTraining.Keeper = [Animal
Records].KI)
WHERE ((([Animal Records].NT)=25) AND ((StaffTraining.Keeper) Is Null) AND
((StaffTraining.Animal) Is Null));
It returns records like so:
RecordsID Date KI Animal Name
76218 10/24/2008 JS Fern
76219 10/24/2008 JS Rowdy
76220 10/24/2008 JS Tahoma
76221 10/23/2008 TB Colby
76222 10/24/2008 TB Colby
I would like a treeview that shows:
*JS
--Fern
--Rowdy
--Tahoma
*TB
--Colby
But I just don't understand the treeview control at all. I understand you
have to right some code that you put in the OnLoad event of the form the
treeview control is on.
Could I get some help with the code?
Thanks!