Hi everyone!
I have created a form which contains a pick list. In addition, I have several tables which correspond to each of the pick list options. As such, I would like to automate when the form is submitted, it would add a row to the table corresponding to a pick list. For example: My pick list options are Texas, California, and Washington and my tables are TexasTable, CaliforniaTable, and WashingtonTable. If someone selects Washington and submits the form, I would like that data to be stored in the WashingtonTable.
Any help/suggestions are appreciated!