Hello everyone… How can I assign records from one table to many records in second table. The thing is I have 5 records in table1 and 5 records in table2. Each record from table1 can be able to assign many records from table2.(1st record from table1 can have 2,3,4,5 records in table2). How can I do this. Can anyone help me in this issue?
If the relation is m:n, you have to create an additional table to represent the relationship. It will hold primary keys of both tables and each record will represent relation between two individual records.
Using you example, the data would like like this: