N
Nugs
Hey there everyone.
I hope you guys can help me, I am somewhat of a newbie when it comes to
giving the database some of the control when designing my web applications.
I am doing a site right now that is one of my more complicated and I'm
almost forced to use stored procedures or queries as I believe they are
called in Access to do some of this stuff.
I'm not sure if my approach to doing this is all that correct so my question
is more of a request for some advice on what the best thing is to do in this
situation.
Basically I am doing the user registration for this website. I have two
tables: 1)UserInfo 2)LoginInfo. I'm sure you can imagine there fields
reading there names. Both have one field in common, this is called 'MemNum'
field. the 'UserInfo' tables 'MemNum' fields is a AutoNumber field the other
'MemNum' field is a Number field.
Now what I am trying to do is create one form where the new user can go on
my website and enter all there information. What I need is a query that
inserts all the form information (Which includes LoginInfo) into there
different tables and copy the 'MemNum' field that was generated (AutoNumber)
in the 'UserInfo' table to the 'MemNum' field in the 'LoginInfo' table.
Once again this is not necessarily the way it should be done, it's how I am
trying to do it, but I am more than open to any more suggestions on how I
can insert and entire form of information into multiple tables and have the
records in those tables correspond to each other by the 'MemNum' field all
in one step.
Thanks
Nugs
I hope you guys can help me, I am somewhat of a newbie when it comes to
giving the database some of the control when designing my web applications.
I am doing a site right now that is one of my more complicated and I'm
almost forced to use stored procedures or queries as I believe they are
called in Access to do some of this stuff.
I'm not sure if my approach to doing this is all that correct so my question
is more of a request for some advice on what the best thing is to do in this
situation.
Basically I am doing the user registration for this website. I have two
tables: 1)UserInfo 2)LoginInfo. I'm sure you can imagine there fields
reading there names. Both have one field in common, this is called 'MemNum'
field. the 'UserInfo' tables 'MemNum' fields is a AutoNumber field the other
'MemNum' field is a Number field.
Now what I am trying to do is create one form where the new user can go on
my website and enter all there information. What I need is a query that
inserts all the form information (Which includes LoginInfo) into there
different tables and copy the 'MemNum' field that was generated (AutoNumber)
in the 'UserInfo' table to the 'MemNum' field in the 'LoginInfo' table.
Once again this is not necessarily the way it should be done, it's how I am
trying to do it, but I am more than open to any more suggestions on how I
can insert and entire form of information into multiple tables and have the
records in those tables correspond to each other by the 'MemNum' field all
in one step.
Thanks
Nugs