| dynamic populate drop down list [message #376242] |
Tue, 16 December 2008 10:11  |
mindy
Messages: 4
Registered: December 2008
|
Junior Member |
|
|
Hi,experts,
I have a multiple data block that has a drop down list.
The list must be populated dynamically according to the other item of the same record.
So in WHEN_NEW_RECORD_INSTANCE, I has the code as
IF <condition 1> THEN
P_ENABLE_DISABLE_ITEM('MLB_TEST.TXT_REASON',CURRENT_RECORD,'T');
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD,'MLB_MEMBER_DETAILS',STATUS,NEW_STATUS);
CLEAR_LIST('MLB_TEST.TXT_REASON');
ADD_LIST_ELEMENT ('MLB_TEST.TXT_REASON', 1, C,C);
ADD_LIST_ELEMENT ('MLB_TEST.TXT_REASON', 1, D,D);
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD,'MLB_TEST',STATUS,QUERY_STATUS);
ELSE
P_ENABLE_DISABLE_ITEM('MLB_TEST.TXT_REASON',CURRENT_RECORD,'T');
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD,'MLB_TEST',STATUS,NEW_STATUS);
CLEAR_LIST('MLB_TEST.TXT_REASON');
ADD_LIST_ELEMENT ('MLB_TEST.TXT_REASON', 1, E,E);
ADD_LIST_ELEMENT ('MLB_TEST.TXT_REASON', 1, F,F);
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD,'MLB_TEST',STATUS,QUERY_STATUS);
The reason list of the first record in the block is showing C,D. but the reason list of the second record in the block is showing E,F,C,D.
How I can achieve the result that the reason list of the first record in the block is showing C,D and the reason list of the second record in the block is showing E,F.
Thanks
|
|
|
|
|
|
| Re: dynamic populate drop down list [message #376557 is a reply to message #376302] |
Wed, 17 December 2008 17:57  |
mindy
Messages: 4
Registered: December 2008
|
Junior Member |
|
|
|
I am a beginner. Can you give more details on how to create LOV and record group and attached it to a drop down list. And the can the query that associates with the record group accepts paramters?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
