Context: My base is set up into three tables: Videos, Scenes, and Footage. Since some shots of footage may appear in more than one video, the Scenes table is functioning as a junction to preserve the shot chronology unique to each video. I'm trying t...