Re: Normalizing Tree Data
Date: Fri, 8 Feb 2008 12:20:07 -0800 (PST)
Message-ID: <dad56185-fb4d-4359-8abe-7ed7ab757c67_at_n20g2000hsh.googlegroups.com>
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
Received on Fri Feb 08 2008 - 21:20:07 CET