How to insert data into two different tables with the same form?

Asked

Viewed 172 times

0

I have a dynamic form where the questions come from a database table, some questions have multiple choice answers that also come from the database. but other questions are text questions. When doing Submit required multiple choice responses to be for one table and text responses to another table.

How do I differentiate the responses that come from the checkbox and send to table x and the text responses to send to table y?

Follows a scheme (a little rough but with the information I think relevant) BD

inserir a descrição da imagem aqui

Thank you

  • 1

    How’s your bank modeling? I could explain, but I think it would be better if you show your modeling to answer be more suitable to your bank.

  • Diego Felipe,Thanks, I already edited the question and inserted a partial schema of the database, ie I at the time of doing Submit I need to pick the answers questions that are text type to the table (tblClienterespostaTxt) and in the multiple responses that are checkbox to the other table (tblClienteRespostaPre)

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.