yes, but you'll need to load up all the info from the db and store it in javascript arrays, then use the onChange method of the select box to refill the text boxes on the page. Depending on how much info is in the database you might want to consider if its worth doing this on one page as it could be quite slow to load if its very big. hope this helps Dan -----Original Message----- From: shaun [mailto:shaun@mania.plus.com] Sent: 10 April 2003 12:36 To: php-db@lists.php.net Subject: Populating fields dynamically Hi, I have a table called offices in my database. Each office has an ID. Is it possible to have a drop down menu on a page so that when an office id is selected from it, the other text fields on the are populated i.e. office name, office address, office telephone number? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php