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 to create an interface for planning a video with fields linking to corresponding Scenes and Footage.
Issue: I can't figure out how to get the footage record picker to show pre-existing records that aren't already linked to the scene. I have no filters on the record picker.
