Thank you Mark. After doing a bit more research I have come to the same conclusion. I am new to this, so it will be a challenge to get this...

I have been working on all morning and I am stuck.

This is my stored procedure

...

Thank you, this sounds like a great solution.

Sorry for the delay have been working on my navigation system.

I have my login all set based on a user_name which works great. It passes the user_name and the user's...

I figured that was the case with the Scope_Identity()

All of my tables are linked with the UserID which is the Identity field in the User table.

So I would just...

Hey Phil,

I have another form that follows the first one you helped me with. I wanted to make sure I am on the right track with my stored procedure.

ALTER...

Will test it tomorrow. I am not able to access the SQL server from the IP.

Thank you for all of your help Phill

-Curtis

I am using Visual Studio.net and the web host has a sql manager page where the usersroles table was created. The users table already existed.

Yes, UsersRoles is the right name for the table. I don't know if this makes a difference but the Users table is listed as Users(dbo) and UsersRoles is just UsersRoles....

Phill, thank you!

It now ads the new user to the users table but it also gives me this error message:

Server Error in '/Global' Application.

--------------------------------------------------------------------------------

Invalid object name 'UsersRoles'.

Description: An unhandled...

No the UserID is the IDENTITY column.

I don't have a stored procedure set up for UserRoles

This is my stored procedure that I call when the user hits "Register"

ALTER PROCEDURE...

Ok, I DECLARED @NewID as an INT.

I made your suggested changes to the stored procedure except I removed the RoleID because it has a default value associated to it.

The...

I use a stored procedure.

How will I pull the userId from the main table to insert into to the UsersRoles table

this is my stored procedure

@LastName...