I created a login page using the Log In User option from the Application menu. I tested it on IIS and it works great. However, my main goal is to have the user log in and have information from two tables displayed, but only the information pertaining to that user. I have been beating my head against a brick wall for two days trying to accomplish the latter.
I had thought of using a session variable from a form, which I did successfully build using the example in the help files. But I cannot seem to accomplish doing the same thing with the login form due to the action on the form already being coded to work in conjunction with the Log In User option. To be clearer, I cannot seem to figure out a way to accomplish both items on the same page (login page). Am I doing something wrong, missing something?
I had also written a SQL query to pull the information from both tables, which did in fact pull the information, but it was not displaying it correctly. I would like to have the username be the variable that allows the pages to pull that user's information from both tables. Is that also the wrong way to go about it?
~E
I had thought of using a session variable from a form, which I did successfully build using the example in the help files. But I cannot seem to accomplish doing the same thing with the login form due to the action on the form already being coded to work in conjunction with the Log In User option. To be clearer, I cannot seem to figure out a way to accomplish both items on the same page (login page). Am I doing something wrong, missing something?
I had also written a SQL query to pull the information from both tables, which did in fact pull the information, but it was not displaying it correctly. I would like to have the username be the variable that allows the pages to pull that user's information from both tables. Is that also the wrong way to go about it?
~E