title: Selecting data from a table and auto-filling fields
body: <p>I'm working on a small little project, at the moment just a test for a larger project, but I've hit a block that I can't find a solution too.</p>
  
  <p>I have a list of items in a table, and they contain information such as the item name and the price. I have another table with sales. I have a form that will allow you to select a item name, however, then I would like the rest of the form to be auto-filled with information from the items table.</p>
  
  <p>I can make a message box appear when the item name field has been changed, however, through my searching, I am unable to find a way to search the items table for the value of the field, then read the price value, then insert the price value into a field in this form.</p>
  
  <p>First table "items":
  itemname: text
  price: currency</p>
  
  <p>Second Table "sales":
  itemname: text
  price: currency
  date: time/date</p>
  
  <p>I hope I have explained myself well enough, if not, just ask and I will try to clarify.</p>