database?

Let say we created two tables the first for projects_tbl and the Second user_tbl ---- Now we want the ability to log the user in and see both the user info and the project info. How do we go about this?

As of now we got a standard login form (dream weaver) that uses the projects_tbl with fields project_number (used for Username) and password..

Not sure if we could just join the two Tables or create a Third table and somehow accomplish this task?

depends, does each project relate to one user - one to one relationship?

or can a project belong multiple users - many to many relationship.

if the project can only belong to one user, the projects table should have a user ID column, and in that column, store the ID of the user it relates to, then use a standard join query. see the following page for more details:

http://www.w3schools.com/sql/sql_join.asp

project belong multiple users - many to many relationship

Ok, so in that case you need a 3rd table to link the two and create the many to many relatonship.

projectusers:
projectuserID - primary key
projectuserUserID - relates to the users.userID column
projectuserProjectID - relates to the projects.ProjectID column.

so then for the login page we should use the projectusers_tbl Table?


Then we would have to add a record set to the users table every time we want the user to access a project?

And then on the login success page we would use the projectUsers_tbl Table to accomplish are task of displaying user info and project info?

no, the login page will use the users table.

when the user logs in, the ID from the users table is stored in a session.

Use that to return the info from the projects table for projects that belong to the user by creating a join query to join the projectusers and projects table.

I think the projectusers_tbl that I did is wrong... I think it should be -- userID and project_id ??

Then I think the users_tbl needs a foreign Key (project_id) ?

no, you don't need a foreign key in the users table.

the keys are in the userprojects table.

the userprojects table is used to create the user to projects relationships.

this is similar to the items and genres concept from the Mage relational Data tutorial:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=25

so the projectusers_tbl table is setup correctly?

Yes, it has the columns that relate to users and projects to create the many to many relationship.