Dynamically populate fileds/dropdown from a MySQL database

Hi

Is it possible to dynamically populate a field/dropdown using a previously selected value to query a database table.

Example:
Dropdown A - select a store. ---> store value is then used in a query on the database to bring back all staff names working at that store.
Dropdown B - is then populated with the staff names returned from the query on the DB table.

Thanks
Clinton

Thanks David for the reply.

Do you have any preferred companies that can do this modification to your product.
Do you perhaps do this service yourselves? Or should I try a site like elance?

Thanks
Clinton