2. ASPRunnerPro General questions
  3. new version
This topic is locked

new version

 		6/20/2006 2:21:20 AM
ASPRunnerPro General questions
virtualbox author

In the new version, it is possible to extend the function:
step 9 - user can see and edit their own data only
in the passage:
step 7 - lookup wizard - lookup table.
I hope to have been clear.
Giampaolo (Italia)
Sergey Kornilov admin 6/20/2006

Giampaolo,
you can achieve this using WHERE clause of Lookup wizard.
Build WHERE clause using Session("UserID") to diplay records that belong to current user only.
virtualbox author 6/22/2006

Sergey
I have followed your indications, but I have not been successful, the browser signals different errors.
Giampaolo
K
 		kat 6/23/2006

Giampaolo,
please post your WHERE clause here, I'll help you to correct it.
virtualbox author 6/24/2006

Here is a part of the project
Involved charts:
Table:
field:

ID

ID Riferimento

Ufficio - - > Lookup table (1)

Ecc ecc
(1)

Table: [color=#FF0000]Tab_Ufficio (field: ID - ID Riferimento - Ufficio)

Link field: Ufficio

Display field: Ufficio
ID Riferimento = Users/Main table OwnerID field
Thanks Thanks Thanks Thanks

Giampaolo <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9313&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Alexey admin 6/26/2006

Hi,
I suppose this is WHERE clause you need:

"ID Riferimento = " & Session("OwnerID")
virtualbox author 6/27/2006

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9378&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
It doesn't work, when I have been returning for the vacations I retry.
This program is beautiful for its simplicity, to integrate this function with a "click" it is not a bad idea.
Good job
aolo <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9378&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />