I am creating a content database and calendar to manage content projects and the individual assets that are associated with them. The doc is arranged in a multidimensional schema with separate tables looking up lists and other tables.
I am trying to solve how to create a column (Content Calendar.All Projects) that populates content dependant on a field of a row referenced in another column (Content Calendar.Project Type). The column with the row reference (Content Calendar.Project Type) is a lookup list that multiple tables lookup. I would like to filter (Content Calendar.All Projects) so that only rows on Video Assets or Article Assets table with the corresponding Project Type are available to select in the (Content Calendar.All Projects) list.
I will also add that I’ve been quite intentional about having this schema design in order to separate the different items, rather than having filtered views of a master table.