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!
