No problem about the "add" snafu. Happens all the time.
In order for a user to be able to view and modify his own record, he must first log in. That's the only way for the script to associate a record with a specific user. So you won't be able to have $auth_allow_default = 1.
Here's what I would suggest:
Reg_ID => [0, 'alpha', 3, 12, '', '',
$db_key = 'Reg_ID';
$db_key_track = 0;
$auth_no_authentication = 0;
$auth_allow_default = 0;
$auth_signup = 1;
@auth_signup_permissions = (1,1,1,1,0);
$auth_modify_own = 1;
$auth_view_own = 1;
$auth_user_field = 0;
This will give each user one record which only he will be able to view or modify.
One very important thing is that you cannot have the userid field be a counter field. With your current setup --
Reg_ID => [0, 'numer',
$db_key = 'Reg_ID';
$db_key_track = 1;
$auth_user_field = 0;
you are going to have major problems.
------------------
JPD
Quote:
What I want for functionality, ultimately, is that anyone can add a record and then view own only and modify own record.In order for a user to be able to view and modify his own record, he must first log in. That's the only way for the script to associate a record with a specific user. So you won't be able to have $auth_allow_default = 1.
Here's what I would suggest:
Reg_ID => [0, 'alpha', 3, 12, '', '',
$db_key = 'Reg_ID';
$db_key_track = 0;
$auth_no_authentication = 0;
$auth_allow_default = 0;
$auth_signup = 1;
@auth_signup_permissions = (1,1,1,1,0);
$auth_modify_own = 1;
$auth_view_own = 1;
$auth_user_field = 0;
This will give each user one record which only he will be able to view or modify.
One very important thing is that you cannot have the userid field be a counter field. With your current setup --
Reg_ID => [0, 'numer',
$db_key = 'Reg_ID';
$db_key_track = 1;
$auth_user_field = 0;
you are going to have major problems.
------------------
JPD