Copy data from one record to another

[tubar]

how do i copy the data from one record to another. lets say i have a table of "movies" "best movie 1" has the same director, producer, star as "best movie 2" i need a way to build a form that selects the two movies and copies the data from movie 1(everything except the title) and duplicateds the records to movie 2....

 

[HiTechCoach]

The Director, producer, stars ... should be in a junction table that relates the move to the people table.


See:
How to Duplicate a Main Form and Its Subform Detail Records