Home » Developer & Programmer » Forms » LOV Problem
LOV Problem [message #297449] Thu, 31 January 2008 12:15 Go to next message
daibatzu
Messages: 34
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 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: Assign values dynamically to radio buttons
Next Topic: import from excel
Goto Forum:
  


Current Time: Sat Dec 10 13:12:15 CST 2016

Total time taken to generate the page: 0.08338 seconds