I'm currently developing a .asp webpage using JavaScript as the scripting language. One of the features I have is a drop-down menu with options populated from an 'agencies' table in the database. The 'agencies' table includes various columns such as contact information, phone number, email, and more. When a user selects an agency from the drop-down menu, I want the text boxes below to automatically display the corresponding contact information from the database. Despite searching on Google, I have been unable to find the right resources to implement this feature.
Note: The drop-down menu and contact information are sourced from the same table in the database.