You can first SELECT DISTINCT DisciplineDesc FROM ..., add all parents (it is in this recordset) and then execute SELECT for all childrens.
I never see before use of errors as you did this :-)
Plamen Ivanov MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000) MCSD (VB 6.0/SQL Server 2000) VB (.NET) - what other language do you need in the whole Universe?...
