| LOV Problem [message #297449] |
Thu, 31 January 2008 12:15  |
daibatzu
Messages: 36
Registered: September 2007
|
Member |
|
|
Hi, It's easy enough for me to create an LOV using the Wizard. The problem I have is that I want my LOV to display one thing and return another.
Lets say I have a table called products which has two columns, product_id and product_short_description. I want the user to only see the product_short_description, but for the form to save product_id when saving.
Also, another thing that worries me is search. If I manage to pull this off, when a user wants to search, he will probably try to search with the product_short_description but in this field the value that is actually being saved is the product_id. How to go about this?
|
|
|
|
| Re: LOV Problem [message #297451 is a reply to message #297449] |
Thu, 31 January 2008 12:26  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
1. In the LOV, get both product_id and product_short_description but set the display size of product_id as zero. In the return clause give product_id.
2. In execute_query mode display another field also, so that user can search on the filed, whichever he wants to.
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
