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?
ememAsked:
Who is Participating?
 
madheeswarConnect With a Mentor Commented:
Instead why can't u create a button and use picklist and assign the result to the field and refresh.

Today I am busy and unable to answer all the questions. U just try the logic.

best of luck.
but u can close this questoin as I have answered ur questoin related to this thread.
0
 
madheeswarCommented:
use @Picklict to do it
0
 
ememAuthor Commented:
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?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
ememAuthor Commented:
sorry not dialogbox .....dialoglist that is
0
 
madheeswarCommented:
Its not possible.
0
 
madheeswarCommented:
or can i HAVE ur formula ur using in dialog list.

May be concatenating each value may work
0
 
ememAuthor Commented:
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)
0
 
madheeswarCommented:
what u want to display now as the second column in the dialog list?
0
 
ememAuthor Commented:
column 2 the Account name and the account no. I want to display them both in the dialoglist
0
 
madheeswarCommented:
then in the view, append both Ac name and Ac no like

Ac name+" "+@Text(Ac no)

and this will work for you.
0
 
ememAuthor Commented:
i'll create a new column? or I can append both of them in column 1 which is already existing?
0
 
madheeswarCommented:
into one column. No need to create a new column.
0
 
ememAuthor Commented:
i'll try this
0
 
ememAuthor Commented:
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





0
 
madheeswarCommented:
I am getting. I am sending template to your yahoo /hotmail account.
0
 
ememAuthor Commented:
oh great thanks!!
0
 
ememAuthor Commented:
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?...
0
 
qwaleteeCommented:
Insteaad of using a dialog list, use a picklist.  Interface is much nicer, does exactly what you want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.