>>The table I am extracting information from is not in heirarchical format, but does have a unique record ID field (numeric). I want to create a heirarchical table based on the user selection.
>>
>
>You can create a table that will give you hierarchy info by adding a field that points to a parent record in the same table. This allows you infinite levels in the hierarchy.

Hi Barbara - Thanks for the feedback. This is what I am doing now, but since the data can be resorted (and need to create a new treeview), this table is built dynamically with different parent values, depending upon the sort. Also I need to add the parent node records, since they aren't already in the table.

I was wondering if there is a trick to quickly building the heirarchical table based on the sort fields, as opposed to the rather clunky routine I am now using.