Need help designing a database

I have a two tables users and project, in master_db, which store user details and project details respectively.I would like to solve a problem:I have an .aspx page which will allow me to 'manage' a project, adding users and assigning them roles. I would like to know how to create a table(s) that will allow me to add/remove a 'user' to a 'project'.I was thinking of creating a user_project table that stores the user_id and project_idDo you have any ideas or other solutions to the problem ?
 
Top