Generate Drop Down List base on Condition

Applications Forms
#1

Hi,

I want one of my dropdown field in my form application can generate the dropdown listing based on condition below:

If login user is an administrator then the complete country dropdown list will be shown, else if login user is not an administrator then dropdown list only show the country that registered under login user.

Can advice some solution?

#2

The drop down is created upon a sql statement. In this statement you can apply a global variable like [glob_select]. After logging on you can jump to the next form (sc_redir) and in the onscriptinit you set the global variable [glob_select]=‘1=1’ or [glob_select]=‘mycountry’.

Hope this helps.