I have a form with a drop down list...
-optionA
-optionB
-optionC
-optionD
...each option in the list has it's own table in a database.
-optionA_table
-optionB_table
-optionC_table
-optionD_table
Based on the choice a user selects from the drop-down list, when they submit the form I'd like for corresponding table to be selected within the database so the user just has to hit "Submit" and it posts the data into the corresponding table based on the option they choose in the drop down list. How would you achieve this?