Dropdown record filter

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
crash
User
Posts: 148

Dropdown record filter

Post by crash »

I am trying to run a filter when I edit or add, I want the records in the dropdown selection to only show the same as from the current user.
I am doing this in Filter Editor in the Lookup Table

Eg the current user country = USA
In filter editor "country = 'USA'" this works

I need to use CurrentUserInfo("country")

My code is:
"country= 'CurrentUserInfo("country"))'"
I have also tried
Convert.ToString(CurrentUserInfo("country"))

I get this error CS1002: ; expected

I need the right code to put in the filter editor
I have looked at the help files and tried lookup selecting but this does not work
Please and thanks


MichaelG
User
Posts: 1095

Post by MichaelG »

Try:

"country= '" + Convert.ToString(CurrentUserInfo("country")) + "'"


crash
User
Posts: 148

Post by crash »

Thanks that works, appreciate it.


Post Reply