title: How to make drop-down menu within Oracle Application Express?
body: <p>I would really appreciate if anybody could shed some light on this, as search engine results have been singularly unhelpful so far.</p>
  
  <p>I am attempting to build a GUI for an oracle database through Application Express. There tend to be tricks of how to set up drop down menus through the Graphical User Interface of the product that one uses (for instance I would know how to do this in a product like Microsoft Access).</p>
  
  <p>For instance I have this form</p>
  
  <p><img src="https://i.stack.imgur.com/ZTg7t.png" alt="Oracle Application Express form"></p>
  
  <p>The foreign key for Business (FK_BUSINESS_ID) is just an integer - not terribly user friendly! If it could be a drop down list of business names (BUSINESS.NAME), it would be great. Hiding the business primary key (BUSINESS_ID) would make it look nicer, but isn't altogether relevant.</p>
  
  <p>I have found the source controls for the element in question.</p>
  
  <p><img src="https://i.stack.imgur.com/MmpOy.png" alt="form controls Oracle Application Express"></p>
  
  <p>What sort of SQL (or even PL/SQL) could be used to both display this data from the other table, and return the selected foreign key selected by the user when the form is sent?  </p>