Subject LookupCombo in IBO4
Author Riho-Rene Ellermaa
Yesterday I wasted 2 hours of my life to get LookupCombo to work in grid. In
IBO 3 I have made lots of them, but now in IBO4...

My Main Query
SELECT ID,KORTER,AADRESS
FROM KORTER

Detail query:
SELECT KORTER
, KULU, (select NIMI from KULULIIGID where
ID=EIMAKSA.KULU) as KULUNIMI
FROM EIMAKSA
MasterLink: KORTER=ID
MasterSource: MainQuery

In Form I dropped CustomCombo into DetailGrid.
Query for Combo is:
SELECT ID,NIMI
FROM KULULIIGID
order by NIMI

KeyLink: ID=KULU
KeyDescLink: NIMI=KULUNIMI
KeySource: Detail

When I drop CustomCombo onto Form then everything works, i.e. when I select
some row, then in the Grid the value changes, but on
Grid the Combo stays invisible.

Also when changing master record in middle of detail editing - master record
changes, but detail record remains in the editing mode.

What of the numerous properties have I missed?

Riho-Rene Ellermaa
senior programmer
Hansabank