harry
|
| Posted: 05/20/2002, 7:56 PM |
|
I am try to use the Visual Query Builder to link 2 tables. I have a USERS Table and a USER_ACCOUNTS Table. I have a user_id field in the USER_ACCOUNTS Table and a user_account_id in the USERS Table. I have the same ID Number in both fields and cannot get them to show me any information linked together. I am using CodeCharge Studio Beta 4 and ASP With Templates. I am running a Windows 2000 Server Machine with ODBC and Microsoft Access.
Thanks
Harry
|
|
|
 |
Alex Alexapolsky
|
| Posted: 05/21/2002, 12:09 AM |
|
Have you linked those tables in the builder ?
Linking is done by dragging mouse from one field to another.If you need only some fields to be show you should check them in the builder.
|
|
|
|
harry
|
| Posted: 05/21/2002, 5:45 AM |
|
I did find out that I could only drag from the direction of the main Table and not the table I had added to the Visual Query Builder. I link the 2 ID Fields together. Whenever I log into my project with my user name. I see the right data and whenever I log in with another User Name I see the data also. I should not see the data when I log in with the other user name. I have a form with a Table and Record. I Log in with my user name I want to see only the data responding with that user name.
Thanks
Harry
|
|
|
|
Nicole
|
| Posted: 05/21/2002, 5:58 AM |
|
Harry,
you should protect page with login/password and add session variable "UserLogin" to Where clause of Grid form query.
|
|
|
|
harry
|
| Posted: 05/21/2002, 4:06 PM |
|
Thanks Nicole for your response. I still can't get it to display the proper data. I put my Where statement as follows.
Where = Session("UserID")
Thanks for your help
|
|
|
|
harry
|
| Posted: 05/21/2002, 4:58 PM |
|
I got it working. In the Where Builder I chose my Data ID field and in the Parameter textbox I put the UserID and then chose Session as Type.
Thanks
Harry
|
|
|
|
