emem
asked on
Displaying 2 columns in a dialoglist
Is there a way wherein I can display 2 column values of a view in a dialoglist in my form?
use @Picklict to do it
ASKER
hi there!!! its like this I have a dialog box and I want the 2 columns in a particular view to be displayed in that dialoglist....is that possible?
ASKER
sorry not dialogbox .....dialoglist that is
Its not possible.
or can i HAVE ur formula ur using in dialog list.
May be concatenating each value may work
May be concatenating each value may work
ASKER
this is the formula you also gave me remember this? it only shows one column in the view I want the dialog list to contain col 1 and col 2 of the view here it is
lutype:="Notes":"NoCache";
db:=@DbName;
View:="AR";
col:=1;
tmpkey:=@Unique(@Explode(@ Text(@DbCo lumn(lutyp e;db;view; col));" "));
@If(@IsError(tmpkey);"No Entries in View";tmpkey)
lutype:="Notes":"NoCache";
db:=@DbName;
View:="AR";
col:=1;
tmpkey:=@Unique(@Explode(@
@If(@IsError(tmpkey);"No Entries in View";tmpkey)
what u want to display now as the second column in the dialog list?
ASKER
column 2 the Account name and the account no. I want to display them both in the dialoglist
then in the view, append both Ac name and Ac no like
Ac name+" "+@Text(Ac no)
and this will work for you.
Ac name+" "+@Text(Ac no)
and this will work for you.
ASKER
i'll create a new column? or I can append both of them in column 1 which is already existing?
into one column. No need to create a new column.
ASKER
i'll try this
ASKER
it worked but it does not display the values in 1 line..it is displayed this way
103214 -
EGM G. HENSON
222222 -
JERRY WHITE
its better if displayed this way
103214 - EGM G. HENSON
222222 - JERRY WHITE
103214 -
EGM G. HENSON
222222 -
JERRY WHITE
its better if displayed this way
103214 - EGM G. HENSON
222222 - JERRY WHITE
I am getting. I am sending template to your yahoo /hotmail account.
ASKER
oh great thanks!!
ASKER
it works!! it is possible that it displays 2 columns but when I select the record it will only display the acct no alone?.....this is how it goes when I click on the dialog list it will display 2 columns when I select the data I want it will only display the acct no in the field ....do u get it? or it is really impossible to be done?...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Insteaad of using a dialog list, use a picklist. Interface is much nicer, does exactly what you want.