| Using LOV for multiple items [message #80545] |
Wed, 09 October 2002 23:00  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
Hi to all!
I Have an LOV in forms i wanted to used it in
multiple columns or fields. Can i use 1 LOV for more than 1 columns. Can i used a parameter in LOV and How can i mapped the 1 i pick in LOV in columns. Can anyone help me. I do appreciate it.
thanks
susane
|
|
|
|
| Re: Using LOV for multiple items [message #80547 is a reply to message #80545] |
Thu, 10 October 2002 03:10  |
Shiju
Messages: 12
Registered: October 2002
|
Junior Member |
|
|
1) Yes by giving multiple columns in select stmt,
u can use multiple columns
2)In the where condition u can use a bind variable
like where empno = :ENO
3)Click on LOV properties -
There is a property called Column Mapping
In that u can use the return item to catch/map the value of the selected item from LOV by user.
Eg. if u give Return Item as GLOBAL.MYVALUE
the value selected will be available in that global variable. Do not use : before Return Item
Or u can also set the return item to some TEXT ITEM, to see the selected value on the Form
Again do not use : before it.
Any more queries...let us know.
Shiju
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
