Filter grid based on options from another table

Topic Labels: Data Interface Designer Views
355 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have 4 tables in my base:

  • Staff
  • Group
  • Team
  • Deliverables

The Staff table has a linked record to determine a person's Team/Group.  The Deliverables table has a linked record to determine what staff is working on a deliverable and a lookup value to show their group & team.  The Team table has a rollup field with all Deliverable key values.  Note for complex org structure hierarchy and the need to look at what a group is doing vs what a team within a group is doing, I can't create a simple Option list in Staff with all possible Group/Team combos.

I'd like to create an interface where I can see what deliverables a given Team is working on.  If I put in a record selector for the Team table, I can pick a specific team and get the list of deliverables.  However I see no way to expand the list into a record picker.

If I start with a record picker and link it to the Deliverables table, I don't see a way to create a filter that restricts the options to the Teams values.

What am I missing?  Thanks!

0 Replies 0