Have Geek Brain

Filling in a text box on a form - oracle

I am using the app builder in oracle - and I have a new entry form for cinema opening times.

Basically at the moment I have this, so you can put the movie id in the cinema, but the problem is you need to know the id, so it is not very user friendly. I would like this id to be dynamically included in the form in some way by selecting the theater name from the dropdown (I was able to enable the cinema dropdown)

How can I fill out the form with the appropriate ID based on the selection of the select box in the App Builder?

thanks

0


a source to share


1 answer


Do you mean Oracle Application Express which has a component called Application Designer?

Typical picklist query:

select cinema_name, cinema_id
from cinemas
order by cinema_name;


This will display a list of movie names to the user, and when the selection will write down the value of the item using the theater ID. In HTML expressions, it constructs the SELECT tag like this:

<select id="P1_CINEMAS">
  <option value="11">Ashtead</option>
  <option value="23">Birmingham</option>
  <option value="72">Croydon</option>
</select>

If the user selects "Croydon" from the above list, the value "72" will be sent to the database.

0


a source






More articles:


All Articles