Posted by Zeljko Bilandzija on 10/10/07 12:22

Hello!

I have a problem, and I looking for help if someone can handle this.
I use asp.net 2.0, and I create web site which support users from internet
(Web Site Administration Tool) and with that option i get database named
ASPNETDB.MDF.
When someone via page is creating account, database creates a new record in
aspnet_users table.
I made another table (table User_Data, columns UserID, Level, Points, ...),
and i want that these data are set to some default values automatically when
user press Create Account button (something like this, Columns Level to 1,
column Points to 0, ...)
Which relationship i must use between two tables, and what else i must to do
to be able make this.
I made relathionship FK_aspnet_Users_Users_Data, and set UPDATE statement to
Set Default, and i was set default values for columns in User_Data table,
and when user press Create Account on page, i get error.

I don't know if you understand what i want, but i want to, when user create
new account, that data in other tables are populated automatically for that
user, with some default values, that i specified earlier.

Thanks

[Back to original message]