relationships between tables

[missboom]

Hi there,

this one has been annoying me and i know it *should* be simple, im
creating a database that has users, and every user will have an
administrator in charge of them, so one user will have one
administrator and an administrator will have many users. The
administrators will also be a user but will not have an administrator
as that is themselves. User table is as follows

USER TABLE
uun (pkey), lastname, firstname, phoneno, email...... etc

what im having trouble with is replicating the data, i dont
particularly want the admin users email addresses phone numbers
replicated, therefore i would like a relationship and tables that link
a user to an admin user then admin user details can be grabed from user
table, I did have three tables the USER table, a JOINADMINUSER join
table then a seperate ADMINUSER table.

Any ideas?

Cheers :)

[Bernard Peek]

In message <11**********************@g10g2000cwb.googlegroups .com>,
missboom <sa********@hotmail.com> writes

Hi there,

this one has been annoying me and i know it *should* be simple, im
creating a database that has users, and every user will have an
administrator in charge of them, so one user will have one
administrator and an administrator will have many users. The
administrators will also be a user but will not have an administrator
as that is themselves. User table is as follows

USER TABLE
uun (pkey), lastname, firstname, phoneno, email...... etc

what im having trouble with is replicating the data, i dont
particularly want the admin users email addresses phone numbers
replicated, therefore i would like a relationship and tables that link
a user to an admin user then admin user details can be grabed from user
table, I did have three tables the USER table, a JOINADMINUSER join
table then a seperate ADMINUSER table.

Any ideas?

That's one way of doing it. Because everyone is a user you might prefer
to put everyone's details in one table. Add a field called "Admin" and
put the ID of a person's administrator in there, and leave it blank for
administrators. You can then create queries that use two copies of the
same table with a relationship between the uun and Admin fields.

That way you can choose whether to select only administrators with
IsNull([Admin]) or all users.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.