>Thank you Naomi, this was a big help!
>
>
You're welcome. You may also review the other answers in that thread for SQL Server 2005 solution (which is unfortunately not yet an option for you).
>
>>See if
Re: Data Modeling help (recursive lookup) Thread #
1197755 Message #
1197774 can be of any help.
If it's not broken, fix it until it is.
My Blog