title: Python Flask SelectField selection gets DB row and populates the web page Textboxes with DB row entry
body: <p>I am trying to create a Python/Flask web app and currently i am stuck on one thing.  on the Assign Handset page i want to have a drop down box which displays a bunch of user ID from a sqlite database call, and every time a selection is made the other fields on the page get populated with the corresponding data from the database row.</p>
  <p>I have found some tutorials, well, a lot of tutorials which discuss AJAX and PHP, but none for Python/Flask that fit my needs.</p>
  <p>Here is a screenshot of the web page to give you an idea:
  <img src="https://i.stack.imgur.com/PyM6Y.png" alt="Assign Handset" /></p>
  <p>I have been reading about JQuery, but, i got to say, it is way above my head and i am struggling with it. I only recently found out that you cannot run some java script straight from the browser because of security risks and that you need a HTTP server (python -m http.server in my case :-)).</p>
  <p>As you can see from the picture, when someone clicks the soon to be 'TATA SAP Number' drop down box, the selection will get the relating database record and populate the relating fields with the database row details.  I want to be able to do this without having to load the page each time, if possible!</p>
  <p>if someone can point me to a <em>working</em> Python/Flask, maybe JQuery tutorial on how to do this i will be very grateful!!!  or point me in the direction of some tutorials which will help me build up to doing this myself...</p>
  <p>Thank You In Advance</p>