Let`s put it this way. We have 3 tables
Primary Table (PT)
Secondary Table (ST)
Relationship Table (RT) (in this table are stored new relationships that are created between PT and ST)
I have a List from PT shown in the portal, I want to filter that list this way:
I want a dropdown menu to show all records from the ST.
When selecting a record, the Name of that record should match all the rows in RT that have that Name, this way
I will see in the List only the PT rows that have the RT Name matching the ST Name.