One Form To Update Different SQL Tables Based Upon Form Selection

Hello,

My company Intranet has a form that agents can use to post their comments about the company to upper management, but our customer service department would like to modify the form so that the agent has to pick from a comment type.

The dropdown options on the form will be as follows:

Compliments
Complaints
General Comments
Suggestions

Each dropdown option has a designated table in a SQL DB.
Using postback on the same page, I need to change which fields of the form are visible based upon which dropdown selection the user chooses, and I need the fields to then be inserted into the table that corresponds with the dropdown selection item.

For example: If the Compliments dropdown selection is picked, I need a text box to show for the user's location, the name of the customer, account number, and the message box. Once the submit button is clicked, the characters in these boxes need to be inserted into the Compliments table using its data adapter.

However, if the user selects Suggestions, the name of the customer and the account number should not be visible, since these fields do not exist and when the submit button is pressed, the Suggestions table should be updated.

If you need more information, I will provide whatever is needed.

As always, thanks for everyone's assistance.

Chris