I think four LookUpCombo´s is not a good idea.

Why y not create four search buttons to access only one find/search/locate
window (returnt only the code ofcoarse), and do four sub-selects in the
master select to return the name of contacts.

And other, if you compare directly the fields, it compare contact1 with
contact.id and at the same record, it compare with contact2,..3...4 it´s
very confuse to Server, maybe it not work...

==============================
Eduardo Jedliczka
GeraSoft Informática
Apucarana - PR - Brasil
==============================

----- Original Message -----
From: "tickerboo2002" <support@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 21, 2002 8:50 AM
Subject: Re: [IBO] TIB_LookupCombo - Cannot display 1 field only


>
> > 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.
>
>
> drat! I knew it would be something simple. Thanks
>
>
> One related question.
>
> If my customer table has 4 entries:
>
> Contact1
> Contact2
> Contact3
> Contact4
>
> which are all FK's into the contact table, it appears that in order
> to have 4 lookup combos listing all the contacts, I need 4 queries
> and 4 datasources to link up each combo.
>
> I naively thught I could just add
>
> contacts.contact_id=customers.contact1
> contacts.contact_id=customers.contact2
> contacts.contact_id=customers.contact3
> contacts.contact_id=customers.contact4
>
> to my contacts query keylinks. I was wrong.
>
> Am I forced to use a query and a datasource for each TIB_LookupCombo?
>
> TIA
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>