Link to home
Start Free TrialLog in
Avatar of emem
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?
Avatar of madheeswar
madheeswar
Flag of Singapore image

use @Picklict to do it
Avatar of emem
emem

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?
Avatar of emem

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
Avatar of emem

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(@DbColumn(lutype;db;view;col));" "));
@If(@IsError(tmpkey);"No Entries in View";tmpkey)
what u want to display now as the second column in the dialog list?
Avatar of emem

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.
Avatar of emem

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.
Avatar of emem

ASKER

i'll try this
Avatar of emem

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





I am getting. I am sending template to your yahoo /hotmail account.
Avatar of emem

ASKER

oh great thanks!!
Avatar of emem

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
Avatar of madheeswar
madheeswar
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Insteaad of using a dialog list, use a picklist.  Interface is much nicer, does exactly what you want.