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??




Parm