title: Can I use DropDown menus to retrieve values from a database
body: <p>Below is the "Room" table in the database:</p>
  
  <pre><code>   Room          Building            Capacity
      CW5/10        Canalside West        50
      CW4/09        Canalside West        40
      CW2/08        Canalside West        40
      CW4/10        Canalside West        25
      CE1/03        Canalside East        40
  </code></pre>
  
  <p>What I want to do if it is possible is to create 2 dropdown menus. One dropdown menu is for the "Building" field where it will displays all the buildings as individual values in the dropdown list and then in the second drop down menu, it will display the list of rooms which is</p>