I have a table with it's design based off an excel sheet I was using for my movies. Now I am switching over to using a junction table based on a movie table and actor table. Is it possible to create an append query to take the movie name and one of the actor columns and append it into the junction table?