EB Dynamic list in window after selection

[MireilleChalifour]

In ArcGIS Experience Builder: I have a list (organisation - table 1) that opens a window for this specific selection, showing the organisation's details.

However, I need another list in that window showing projects (table 2) for that specific feature of table 1 (organisation). The data is supposed to be related by ids, and have the value in both table (both table have same the organization name)

I cannot find the right way to connect the projects to the specific organization window, using different data filters.

What is the right way to do this?

[NicoleJohnson]

@MireilleChalifour, more information might help answer your question. In case it helps, here's an example I threw together:

I have a list widget connected to the default data view of some waterbodies (table 1) data. The waterbodies each have a GUID, and I have a related table with information (advisories, table 2) about the waterbodies (connected by the GUID). In the list widget, under "States," I've set a link to a window I created that has a list of the related features. In order to see just the related features in the window when I click on a waterbody, I need to either filter them or select them.

To filter, add a message action saying that when you select something from the table 1 list, filter the action data (table 2; note that the data view has to be the same as the one you're using in your window--this seems to trip a lot of people up). 

Result:

If you'd rather select the table 2 features, change what happens when you select a table 1 record, but...

Also remember that your window/table 2 data has to then be using the selected data view: