attach multi-column of LOV with multiple display-items [message #181352] |
Sat, 08 July 2006 23:43 |
bornlooser
Messages: 20 Registered: September 2005 Location: Jakarta
|
Junior Member |
|
|
Dear All,
i have a LOV with multiple columns and i wants to attach with multiple display-items NOT TEXT-ITEM. means when i select an entry in LOV and press OK, all four column values should get filled in respective display-items. please advise to setup.
regards
Sunny
|
|
|
Re: attach multi-column of LOV with multiple display-items [message #181905 is a reply to message #181352] |
Wed, 12 July 2006 02:37 |
jowahl
Messages: 82 Registered: May 2006
|
Member |
|
|
try to implement this function in the KEY-LISTVAL trigger:
LIST_VALUES;
--
-- if user had picked a value, execute some code:
--
IF :<BLOCK.FIELD> IS NOT NULL THEN
:<BLOCK.FIELD2> := '.....';
:<BLOCK.FIELD3> := '.....';
ELSE
--
-- no values had been picked; clear items:
--
:<BLOCK.FIELD2> := NULL;
:<BLOCK.FIELD3> := NULL;
END IF;
hope this works ...
|
|
|