Extract values from lookup tables

[kate83]

Hi all,

I've created 3 tables as follows:
User_Login:
user_id PK NOT NULL AUTO_INCREMENT,
user_username VARCHAR(30),
user_password VARCHAR(30)

Projects:
project_id PK NOT NULL AUTO_INCREMENT,
project_name VARCHAR(30)

Mapping:
user_id PK NOT NULL,
project_id PK NOT NULL

The Mapping table serves as a lookup table where it can keep track the user is assigned with which projects . So when the partiular user is logged in, there will be a project dropdown list where it will show the projects which the user can access.

Is there any method or something to make the above logic workable?

[laserlight]

Yes, you would use joins. Your design is well normalised if you expect a many-many relationship between users and projects 🙂

[kate83]

Thanks for your help, i'll try it out first 🙂