Witango-Talk: dropdown menu items display??

[Cecilia Cos]

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 57^th Street | New York, NY | 10019
212-445-4309
[EMAIL PROTECTED]

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf