Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get a combo box

Mark1970Oct 8 2012 — edited Oct 8 2012
I'm a newby in Forms.
I've created a form based on a view based on two tables.
To use this view for inserting values I've used succesfully an instead-of-trigger.
What I don't know how to do is how to report a combo box for one of the values.
I try to explain by an example.
Let's suppose to have a PERSON table (name, sirname, age, ...) and a GENDER table (id_gender, gender_description) where gender_description is Masculine or Female
My view is made of all of the columns of PERSON and gender_description of GENDER
When the form allows me to insert a new person, I'd like that in the field of gender_description it were reported to me a combo box with Masculine or Female so as to permit to me to choose and then the instead-of-trigger will insert into the PERSON table the new values of name, sirname, age + id_gender (which is a foreign key to GENDER table).
What and how to use for getting a combo box? LOVs or what else and how to create it?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2012
Added on Oct 8 2012
1 comment
204 views