I work in the film industry and am trying to create a base to help me track my work.
I make graphics for sets. A graphics might be something that hangs on the wall in a set, so it would be in every scene that's shot on that set. Or it might be a prop like a newspaper, that only appears in ONE scene on that set. I'm trying to build a schema that allows for both. If a graphic is in every scene, I would like to have to enter it just once for the set, and have it somehow linked automatically to every scene that is on that set. If a graphic in only in one scene, I'd like to have it listed in only that scene.
I've set up a demo base with linked tables for
Right now, the way it set up, the only way that I can set a graphic for all scenes on a set is to manually enter it for each scene. I'm trying to figure out a way to automate this or to have a different schema that accomplishes it.
Thanks for any help or thoughts.