Home » Developer & Programmer » Forms » LOV Problem
LOV Problem [message #297449] Thu, 31 January 2008 12:15 Go to next message
Messages: 34
Registered: September 2007
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 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
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.

Previous Topic: how to find errors occured during execute_query
Next Topic: FRM-30409: Delete Record Behavior for the relation is invalid.
Goto Forum:

Current Time: Sat Aug 19 11:59:10 CDT 2017

Total time taken to generate the page: 0.15811 seconds