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

Hi all,

I have the tables

customer
customer_id (pk)
customer_name

timesheet
timesheet_id (pk)
customer_id(fk)

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

thanks
Re: LOV problem [message #222683 is a reply to message #222654] Mon, 05 March 2007 22:46 Go to previous messageGo to next message
kamran.it
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
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

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: Sun Dec 04 06:51:44 CST 2016

Total time taken to generate the page: 0.09944 seconds