At some point, you have to have a constant reference. The idea behind the control is that its source is the result of a SQL Statement. With the AS clause of the Select statement, you can overcome this limitation, albeit a slight, very slight limitation.

The two key words in your reply: Worked and Great work for me...

Glad things worked out for you..


>Thanks John for the treeview it worked for me great. But just for your reference even in your treeview the fields were hardcoded.
>
>Regards
>Bhavbhuti