create a custom column under the search action by right-clicking in the columns area.
then create the column (FirstName + ' ' + LastName) as FirstLast then just use the new FirstLast Column in the @Choicelist Ben Johansen -----Original Message----- From: Cecilia Cos <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Fri, 16 Jul 2004 10:14:32 -0400 Subject: Witango-Talk: dropdown menu items display?? > Hello, > > I have 2 tables in SQL....TrafficLog and PhotoEditors > > In the Table TrafficLog you have the following fields > ID > Date > Login > PhotoEditors > Condition > > In the Table PhotoEditors you have the following fields > ID > FirstName > LastName > > I have created an add new record form using the new record builder for > Table TrafficLog . > > I would like to have the field PhotoEditors in the Table TrafficLog be > a > dropdown menu displaying the PhotoEditors items in the Table > PhotoEditors > and when saved the item goes in to the PhotoEditors field in the Table > TrafficLog . > > I have done the Search action for PhotoEditors table with the 3 fields > > <TR ALIGN="LEFT" VALIGN="TOP"> > <TD> > <B>Send To: </B> > </TD> > > <TD> > <@CHOICELIST name=TSend TYPE=SELECT SIZE=1 > OPTIONS=@@PEName[*,2] > VALUES=@@PEName[*,2]> > </TD> > </TR> > > My question is how do I get Firstname and Last name displayed in the > dropdown menu...right now it is only displaying first name? > > Thanks in advance for your help.... > > Cecilia C. Cos > Data Analyst > Newsweek | 251 W 57th Street | New York, NY | 10019 > 212-445-4309 > [EMAIL PROTECTED] > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
