| LOV problem [message #222654] |
Mon, 05 March 2007 15:58  |
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 #222762 is a reply to message #222654] |
Tue, 06 March 2007 05:46  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
