[thelist] Database Normalization Question

[Paul Backhouse]

you could have one table for the user, one for the sections and one linking
the users with the sections.

Ie:

[tblUsers]
UserID   UserName
1        Fred Bloggs
2        Joe Bloggs

[tblSection]
SectionID    SectionName
1            Marketing
2            Production
3            Sales


[tblUserData]
SectionID   UserID
1           1
2           1
3           1
1           2
3           2

So User Fred Bloggs is all available sections where as Joe Bloggs is in
Marketing and Sales section.

Doe this help - is this what you were after?

cheers

paul



-----Original Message-----

Let me try to make myself more clear.

I have contact information for people in a company that work in multiple
areas.  I will create web pages that will display each area separately. An
employee could work in more than one area.

Does that explain things better?

TIA -
Josh