many-to-many relationship

[czarjosh]

what is the best way to design a many-to-many relationship. the scenario is : I have employees and i want to register their concerns.

Such as:

Name Concern
Sally Wages

But I at one point will want to create a report of everyone and there concerns but also a report of every with a certain concern. Is this a many-to-many or a one-to-many relationship.

 

[PHV]

a report of everyone and there concerns
So, an employee may have several concerns.
a report of every with a certain concern
So, a concern may have several employees.
You have to build a many-to-many relationship, i.e. a relation table which Primary Key is composed of the employeeID Foreign Key and the concernID FK.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

So you should have:

tblEmployee
EmployeeID (PK)
EmployeeFName

tblConcerns
ConcernID (PK)
ConcernDesc

tblEMployeeConcerns
EmployeeID
ConcernID (Composite PK)

check out 'The Fundamentals of Relational Database Design'



Leslie