Thinking how to link password to my previous passw
I have currently got a table with username and passwords listed. Along with this tablei have admin_level(which will be replaced with roles) aswell as email information and to which company they belong.
Now if i am to use the interface in asp2.0 then i wil have a table where essentially i have access to three columns which are username, password and the role. How would i compensate for the other rows i need in the table.
Do i create a new table withese additional fields. If so how do i link the 2 tables up, based on username? What do i do if we change the username, how do i update that in the seconed table.
OR IS THIS POSSIBLE
1- setup one user - this will allow the system to set the table up.
2- go into that table and add additional columns that i require for each user such as company etc.
3- then i can extract the info from the users table based on the username etc.
Is this possible??