im trying to run multiple databases, i got a database for each state and would like to know if there is a way to make it so if someone enters something under the default database and for the state filed put like NY it would move it to the NY database. can this bee done?

also i would like to know how to get search results from more then 1 databases
thank you to all the reply