Hi,

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!