| 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 ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
