2. ASPRunnerPro General questions
  3. Lookup table to show only signed on user
This topic is locked

Lookup table to show only signed on user

 		7/15/2008 16:13:13
ASPRunnerPro General questions
C
 cordaco author

I am trying to set up a lookup table that will only show the information that pertains to the logged in user.
I am using Access. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8995&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
jfr 7/15/2008

Hi.
You do this in the Security section of the Tool.

First you have to create Dynamic security, followed by letting Users only see their own data.

Of course in your table you need to have an owner field.

For better instructions, you can have a look here.
John
J
 		Jane 7/16/2008

Hi,
add where clause for this lookup on the "Edit as" settings dialog on the Visual Editor for this purpose.