Subject | LookupCombo in IBO4 |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-06-19T08:15:06Z |
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
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