I,m trying to combine two tables into one. Table 1 is persons. Table two is movies. Table to insert in is, lets say per_mov_table
I'm building a form that will get values from both tables 1 and 2 and insert into a new one.
In that form I can select a person from a dropdown list. And select movies from a select list. Its
possible to select multiple movies per person.
I,m trying with the ADDT behaviors. but I get some strange results.
Lets say I select person nr 2 and movies 2,3 and 4 in the form. Then I would expect results in new table to be something like: (id_fk_pers id_fk_mov are the foregin keys)