Hello Rainer,

> thanks a lot for your instructions! They seem to "mostly" work
> except that I get a exception "field name tls_line_stop.ls_lsr_id
> was not found" when I enter the cell for lsr_reason_text and select
> a item from the combobox (showing up nicely as you described).

You forgot to include tls_line_stop.ls_lsr_id in the select clause:

> SELECT LS_START_DATE_TIME, LS_END_DATE_TIME,

--> add LS_LSR_ID, <--

> LSR_REGION, LSR_REASON_TEXT
> FROM TLS_LINE_STOP
> LEFT OUTER JOIN TLSR_LINE_STOP_REASON
> ON LS_LSR_ID=LSR_ID

(...)

> next QLineStopReasons.KeyDescLinks to : "lsr_reason_text=LS_LSR_ID"

KeyDescLinks should be: lsr_reason_text=lsr_reason_text

(The left hand side being the field from the lookup query, the right
hand side from the keysource query. They are often the same, but
not always.)

OK, if you change those two things it should work.


Greetings,
Paul Vinkenoog