Registration Form

I have a preregistration form on a web site that gathers most
of the information about an instructor. This information goes into
the instructors table in a mySQL database. After his or her
credentials are confirmed, I would like to send the instructor a
registration form that basically allows them to choose a username
and password. The form has 5 fields: first and last name, username,
password, and confirm password. This is really a form with an
update record behavior that has the instructor's first and last
name already displayed on the form when it's sent to him or her and
all the instructor needs to do is to add a username and password
(and confirm the password). However, I cannot use the Check New
Username with an Update Record behavior, it needs an Insert Record
behavior. (I am using php.) Can I use both Update and Insert Record
behaviors on the same form with the same table? I tried and I am
having some problems. I also tried putting the membership info in a
separate table, and that seem to work well except I had great
difficulty writing a SQL statement that would display fields from
two tables without getting duplicates (and no one offered any help
on any my past postings).



There have been a lot of people viewing my posts but no one
stopping by to offer any help. Even if someone can point me in the
right direction, I would greatly appreciate it!Registration Form
I think you are approaching this in the wrong way. What I
would do is have them setup a username and password first and use
the ''insert'' behavior first. This will let you uniquely identify
the user to get the correct records. Then when they register their
username/password, have them redirected to the other form. This is
where you would use the update server behavior. Be sure to check on
login if they have completed this form or not, that way they are
not redirected to this form everytime they log in. Maybe put a
column in the DB named regComplete with the initial value of 0,
then when tnhey have completed the registration form, update the
value ot 1. Then on login, say ''IF the regComplete is 1 then
redirect to the home page or whatever, else redirect to the
registration form.''Registration Form
Thanks for your response. I think in my particular case, I
want the registration form to be the username and password. I
actually had it working when I put the the membership info into a
separate table. That allowed my to use the Insert Record behavior
successfully with just those fields. It worked well but when I
created a report or a membership page to display the membership
info, I got a lot of duplicates and some odd behavior. I main
problem is that I am new to php and mySQL. So, I decided to hit the
books and get a better grasp on the programming.



Thank you very much for your help and comments. I learned
from them!