Can Record Picker Include Unlinked Existing Records

Topic Labels: Interface Designer
357 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1
10 - Mercury
10 - Mercury

Is the interface set up to allow users to edit/create new records?

Let me rephrase - I was getting the kids at school and wasn't able to expand. If you allow for users to edit and create new records in the interface, I think you'll be able to get what you want.