At 09:25 AM 21-08-02 +0000, you wrote:

>I have a TIB_LoopupCombo on my form which is linked via a datasource
>to a query with the follwing SQL:
>
>SELECT CONTACT_ID
> , FIRSTNAME
> , LASTNAME
>FROM CONTACTS
>order by lastname, firstname
>
>I also calculate a field called 'FULLNAME' which is
>firstname+lastname.
>
>Now, my problem is trying to make the lookup combo display FULLNAME
>only. The combo has it's datasource set and the displayfield is set
>to FULLNAME, but when executed, the drop down displays all four
>fields: Contact_Id, firstname, lastname, fullname.
>
>Setting the DisplayField to 'FirstName' gives the same result - all
>columns are displayed.

The DisplayField is the field displayed in the textbox portion of the control.
If you want to restrict the fields displayed in the dropdown (which is a
tib_customgrid) use the VISIBLE property in the Fields Property
editor. Fields are visible by default, so you only need to set the
property on fields you don't want to see in the grid.

Helen