| Values of a combobox from a select [message #330013] |
Fri, 27 June 2008 05:52  |
averno9
Messages: 30
Registered: June 2008
Location: Spain
|
Member |
|
|
Hi all.
I want to put a combobox that is filled with the contents of a query. For example, i have 2 tables, PERSON and CITY. They are like this:
PERSON
------
ID_PERSON NUMBER(3)
NAME VARCHAR2(20)
SURNAME VARCHAR2(20)
ID_CITY NUMBER(2)
CITY
----
ID_CITY NUMBER(2)
NAME VARCHAR2(25)
I want to show in each row of PERSON, instead of the city code, the name of the city, and when i push the combobox all cities that i have are shown. Whenever i try to commit, it will save in the DB the code, of course.
I tried several things. First of all i tried to create a form, an assisted block of person, another of city, and then create a relation between them. But it won't work, of course, i just tried the easiest thing i thought.
Searching for 'combobox' in this forum, it gave me an idea. Using a LOV. I would put the LOV in my combobox, with the id and the name of the city, and try it.
But i'm not really sure of what i have to do... ASP.NET has spoilt me too much i think, i would do this with 3 or 4 clicks, he he!
I tried to google this question, and i found everyone knows how to do this except me, so they don't explain how to do it. I searched on the help, and i didn't find anything useful.
Could you give me some guidance? I don't want that you do it for me, i'm learning and i want to suffer doing this, but could you tell me an url of a white paper, a class name, property or something?
Thanks a lot for reading, and sorry for my english.
[Updated on: Fri, 27 June 2008 05:55] Report message to a moderator |
|
|
|
|
|
| Re: Values of a combobox from a select [message #337162 is a reply to message #330013] |
Wed, 30 July 2008 01:29  |
averno9
Messages: 30
Registered: June 2008
Location: Spain
|
Member |
|
|
No, i haven´t. I tried to do it for a week, but i had a lot of job then, and i had to leave it.
I was just curious to know how to do it, but it wasn't something very important for my work.
Thanks a lot for asking.
|
|
|
|
| Re: Values of a combobox from a select [message #339560 is a reply to message #337162] |
Thu, 07 August 2008 18:32 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
My suggestion is to create an LOV based on a record_group which has the entries in which you are interested, associate the LOV with an item so that when the 'show LOV' button is pressed the LOV appears, then as part of the LOV defined the name of the item into which the data is to be returned. Remember, you can return more than one component of the selected entry.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
