| List Item problem in forms 10g [message #490925] |
Fri, 28 January 2011 03:18  |
shaz
Messages: 182
Registered: June 2009
|
Senior Member |
|
|
I want to dynamically populate a list item such that the item list should show the name and its value should enter in the background.
Please help.
I have tried by writing a query in record group, populated it. the list is showing the name in a list item which is not database item. On this List I have written a trigger which is fetching the value to another text item. It is working well but I am not convinced by this method.
for reference,
i want if customer select
A then list should show balanced and its value is 1
when B then list should show lag,lead,advanced... values 2,3,4,.. respectively.
|
|
|
|
| Re: List Item problem in forms 10g [message #490949 is a reply to message #490925] |
Fri, 28 January 2011 04:29  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
You do not want to dynamically populate a list item at all. It will cause all sorts of problems. You will not be able to change the list items set of values once records have been entered in the screen. You will not be able to query records if the value in the column the list item is based doesn't match a value the list item currently recognises.
Use a text item with an LOV instead.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
