Home » Developer & Programmer » Forms » LOV problem
LOV problem [message #222654] Mon, 05 March 2007 15:58 Go to next message
Messages: 13
Registered: February 2007
Location: manchester
Junior Member

Hi all,

I have the tables

customer_id (pk)

timesheet_id (pk)

i have created a form in which the timesheet_id is displayed.
i wanted to display the customer name on that same form, with the use of an LOV. how can this be done without havin the customer_id displayed in the LOV or the form.

Also when inserting a new record. the timesheet_id is populated using a sequence.nextval, can the customer_id be populated using the customer name value displayed.

for example the form should look like this..

timesheet_id cus_name
1 Customer(selected from an LOV)

hope this makes sense

Re: LOV problem [message #222683 is a reply to message #222654] Mon, 05 March 2007 22:46 Go to previous messageGo to next message
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
you can use this in LOV

select customer_name from customer order by customer_name 

Re: LOV problem [message #222762 is a reply to message #222654] Tue, 06 March 2007 05:46 Go to previous message
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member

When you create your LOV you can select back both the id and the name. If you then go into the column mapping option of the property palette you can set the display width of the id to 0 which stops it being shown on the LOV.

Then you can specify a return item, and when the user selects the customer the values will be put in the selected fields
Previous Topic: FRM - 40102
Next Topic: FRM-92101 bugging me.. please help
Goto Forum:

Current Time: Fri Oct 21 10:12:37 CDT 2016

Total time taken to generate the page: 0.12838 seconds