Maybe it's simple for most, but I would like to know how to implement a n-to-n relationship between Mysql tables using Delphi.
I created the diagram of my DB in MySQL Workbench, I created the DB, all right. My question is: do the tables created automatically when a relationship is made n to n do I need to create a routine to save the data in this table when registering new records, or is it possible to do this automatically?
Complementing the post:
The system I'm doing is for satisfaction search. I will have the tables: Client: Customer data searched: Search: Search Search. Search_questions: table n: n joining the search with the questions that make part of the search Questions: Questions of all searches Questions_options _response: table n: n joining the answer to the answer options of the question (they are all multiple choice answer for each question) Response_Response: All reply options Answers: Table of the research itself, which joins the question, the answer option Customer_response: Connects the client to the given responses.
For the question and answer register, I think it's quiet because I have to register first the questions and answers, then connect the two in the n: n table, the same in the answer options list. My question is really due to the Customer Answers table, because the time I register a new answer, I'll have to register in this table. I would like to know if you have something automatic to save these related data.
In Delphi I will use the default components for accessing databases, or even Zeos Access. Below the diagram.
Perhaps as I do not know very well about this part of DB modeling, there may be a simpler way to create this system, while retaining the flexibility to create new searches, questions, and response options.