At 07:38 AM 15-01-02 +0000, you wrote:

>Helen,
>
>Thanks. Yes I've thought about that. But what about having
>TIB_LookupCombo
>as search fields then? For example I've a list of invoices, each
>invoice is
>linked to an address table via foreign-key relationship. To restrict
>the
>list of invoices for a specific address, this could be done by
>selecting an
>address in a TIB_LookupCombo which is linked to a lookup table
>ADDRESS. Or
>there any other otpions?

Presumably you like the idea of a TIB_LookupCombo because it supports incremental searching...yes? But, of course, the linking behaviour of lookup datasets is only operational in dssEdit mode. You could use TIB_LookupCombo this standalone (i.e. not in a grid) with a separate query populating the lookup list and no key-linking to the master dataset. Better still, - use TIB_IncSearch - it's like the SearchEdit but adds the incremental search capability - v. powerful. You attach it to a column in the same dataset - user types in the first few characters and the dataset positions on the first matching row.

If you have the GSG, there's a simple walk-through there using TIB_IncSearch. You might like to investigate TIB_SearchPanel too..

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com