Hi List,

I have two tables:

CREATE TABLE TLSR_LINE_STOP_REASON (
LSR_ID INTEGER NOT NULL,
LSR_REGION CHAR(80),
LSR_REASON_TEXT CHAR(255)
);
/*----------------------------------------------------------------------------*/
CREATE TABLE TLS_LINE_STOP (
LS_ID INTEGER NOT NULL,
LS_START_DATE_TIME TIMESTAMP,
LS_END_DATE_TIME TIMESTAMP,
LS_LSR_ID INTEGER
);

Where LS_LSR_ID is a foreign key referencing LSR_ID.

What would be the best way to let a user select a TLSR_LINE_STOP_REASON for the TABLE TLS_LINE_STOP?

A combobox with TLSR_LINE_STOP_REASON.LSR_REASON_TEXT as the Items with the selected LSR_ID beeing placed into TABLE TLS_LINE_STOP.LS_LSR_ID would be great, but how can I achieve this?

Thanks for hints
Rainer