>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.