tickerboo2002 schrieb:

>
> Can anyone tell me if this is possible please:
>
> I wish to use a TIB_Lookupcombo to display some contact information,
> my SQL is:
>
> SELECT CONTACT_ID
> , FIRSTNAME
> , LASTNAME
> FROM CONTACTS
> order by lastname, firstname
>
> Can I display 'first+last' as the field in the combo?

Yes, you can define a Calculated Field, fill it with the information of
Firstname + Lastname and display this field.

If neither first- nor lastname can be (or are) NULL you can also let the
server do this job by changing the SQL to:
SELECT CONTACT_ID
, FIRSTNAME
, LASTNAME
, FIRSTNAME || ' ' || LASTNAME AS FULLNAME


But be aware that this is much slower than calculating it on client
side.

HTH
Luc.