title: Using text field value in SQL query without it being submitted
body: <p>I'm using Oracle Application Express (Apex) and basically my situation is: I have 2 items, one is a text field and the other is a hidden item whose value is retrieved by querying a table using a DB link.</p>
  
  <p>What should happen is the user enters a number into the text field, then that number is used in the query for the hidden item to find the row that has a ID that matches the number that the user entered. The value of the hidden item is then set to the contents of one of the columns for that row. </p>
  
  <p>Only issue is, this is all on one page and must be done without submitting the page, so when the user enters the number into the text field, how can I store that number as the value for that item so that it can be used in the query to compute the value of the hidden item?</p>
  
  <p>Any help would be appreciated.</p>