I'm looking for a way to dynamically create a filtered list in a Relationship field. For example, I have a "Contacts" library with over 1,600 entries; each entry has "Company" and "Role" (multi-selection drop down). I have another "Teaming Arrangement" library where we have each project team defined - it has three fields: "Project", "Role", and "Company". Once I select the "Role" (from a drop-down list), I'd like the "Company" (Relationship) to only show me the filtered list of Companies who's role matches that selected.
Aaron Dahl shared this idea