Subject Re: [IBO] Colors for IB_LookupCombo in an IB_Grid
Author Svein Erling Tysvær
Hi Russell!

>However I may have found the source of the problem as either a
>misunderstanding on my part or a shortcoming in IBO.

As usual, it is a misunderstanding and not a problem with IBO (I haven't
found a real error yet). Your problem is DisplayField, it should be the
field of the lookup dataset, not the master. Set DisplayField to COL01A (or
any other column of your lookup dataset).

Set

At 13:53 07.02.2001 +1300, you wrote:
>Hello Svein
>
>I did as you suggested, set up a simple example and its IB_LookupCombo
>inside an IB_Grid works OK. I also read Lars George FAQ note on this topic
>and ensured I had implemented the points of his recipe. Still my App does
>not
>work
>
>However I may have found the source of the problem as either a
>misunderstanding on my part or a shortcoming in IBO.
>
>Start with table GTable supplying IB_Grid using IB_QUERY qrGTable and
>datasource dsGTable. GTable has column COL01.
>
>Insert IB_LookupCombo (LC) into IB_Grid and get its data from table LCTable,
>column COL01A using IB_Query qrLCTable and dsLCTable.
>
>qrLCTable has KeyLinks as LCTABLE.COL01A=GTABLE.COL01 and KeySource as
>dsGTable.
>LC has DataSource as dsLCTable and DisplayField as COL01.
>
>Under these circumstances, when in the grid and the embedded LC is selected,
>the displayed field is blank. But one can correctly select a value from the
>drop down list and the value is accepted.
>
>Now rework table LCTable changing the name of the column from COL01A to
>COL01 and adjust the Delphi code accordingly. The blank field problem goes
>away.
>
>Now rework LCTable back to its original column name. The problem returns.
>
>Have I missed something about linking fields with different names?
>
>Otherwise the qrLCTable.KeyLinks is insufficient to link columns with
>different names.
>
>Regards
>
>Russell
>
>
>
>
>
>
>