I have three tables: Customers, Tasks and customers_tasks. The third table provides the relationship, so a customer can have multiple pre-defined tasks associated with it.
Consider the following:
Customers:
cust_1
cust_2
Tasks:
task_1
task_2
Now, when I create add record cust_3 to the Customer table, I also want to insert into the customer_tasks table a row for each of the tasks, eg:
customer_tasks:
Customer,Task
cust_3,task_1
cust_3,task_2
Is this possible?
User | Count |
---|---|
16 | |
13 | |
8 | |
3 | |
2 |