--- In IBObjects@yahoogroups.com, Geoff Worboys <geoff@...> wrote:

>
> > I had similar issues with this grid control.
> > Converting from a BDE app using TDBGrid controls I had full
> > grid column control with most cells being drop-down lists
> > of values taken from lookup tables.
>
> > Driven by commercial need to get the job done rather than a
> > purist need for perfection I ended up retaining the TDBGrid
> > control but linking it to an IBO Query - the only way I could
> > find to retain the F2 / Drop-down list functionality.
>
> > For later releases, if there is a better way using IBO
> > controls I would be glad to migrate fully.
>
> > Are there any reasons why my approach should not work?
>
> It has been a long time since I used any TDB* components or
> controls in a real app. Can you please explain exactly what
> behaviour you are looking for and perhaps we can help (or
> at least add it to a list of adjustments that are needed to
> emulate TDBGrid).
>
> --
> Geoff Worboys
> Telesis Computing
>

The current setup is as follows:

User input to the grid must be restricted to pre-defined entries
previously entered in small lookup tables.

The need is for either F2 or double click within a grid cell to
display the drop-down list of lookup values for selection. No editing
is permitted, no values other than those in the lookup tables.

A TDBGrid is linked to a TDataSource associated with a TIBOQuery.
The lookup fields are added to the TIBOQuery field list using the
fields editor and related to the source tables.
The TDBGrid gives full control over each of its columns in terms of
format and source field so each column can be associated with the new
lookup fields.

I will email a small screen dump for clarity.

George