Re: Normalizing Tree Data
Date: Fri, 08 Feb 2008 16:41:28 -0400
Message-ID: <47acbe79$0$4029$9a566e8b_at_news.aliant.net>
cr113 wrote:
> On Feb 8, 11:42 am, TroyK <cs_tr..._at_juno.com> wrote:
>
>>On Feb 8, 10:10 am, cr113 <cr..._at_hotmail.com> wrote:
>>
>>
>>>What's the simplest way to set up a relationional database with tree
>>>data? I'm more interested in simplicity vs speed.
>>
>><snip - see OP>
>>
>>People will be able to guide you better if you can expand more on what
>>criteria are important to you.
>
>
> Here are some specifics: I'm using Access. There will only be a few
> thousand records maximum in any table. Around 4-6 fields in each
> table. Very few concurrent users. The users need to be able to add/
> edit/delete any of the nodes in the tree. There are 4 levels in the
> tree. Expanding the previous example it would look something like
> this:
>
> Company
> Division
> Manager
> Employee
What are your most important queries using the tree? Received on Fri Feb 08 2008 - 21:41:28 CET