Posted by Michael_Burgess on 06/08/07 14:57

On Jun 8, 2:56 pm, Seribus Dragon <Seribus.n...@seribus.com> wrote:
> I would Have A lookup Table because you may end up with a person having
> more then one manager.
> UserID|ManagerID
>
>
>
> Michael_Burgess wrote:
> > Hi there,
>
> > I'm fairly new to database design, having only really worked with
> > existing tables etc in the past.
>
> > Simple question this really...........
>
> > In a users table, is it wise to have a ManagerID column that is
> > effectively pointing to another user in the same table, with the
> > theory being that if that person is top dog, they will just have a
> > null entry in ManagerID.
>
> > I will check for circular references before entering the data.
>
> > Is there a better way of storing the data, or is this the only way?
>
> > Thanks,
> > Michael.- Hide quoted text -
>
> - Show quoted text -

Would you be able to give me a very trivial example with some mini-
tables at all please? Sorry to put you out.

Thanks,
Michael.

[Back to original message]