Hi @ola i have a similare problem with owners of a building. I have one layer with my buildings, and another layer with the owners of each buildings.
I"ve try in a first way the selection, but it was not very practical for my users to made a selection of what they want to see.
So i've created a Relationship class between my 2 data, by using a similar id to make a link between the two data sources. With a little bit of arcade i've created on map viewer a popup so when my user click on a building, they can see which owners are on the building.
I wish i can give you a new way to explore to manage your data.
Another way to filter your second data source depending of the first is to have a common ID between the sources, copy the fields that you used to filter the first data source on the second data sources table and set the filter to filter the second data sources by these new field. With that, you can simulate a dynamical approach.