Working on a customer project I came across the requirement to query lists for selectable filter criteria. The query result had to be taken to query a central list. The central list and the other lists had a one to many relation and shared a primary key in the central list.
So lets say there is a customer list with columns „Customer Key“, „Customer Name“, „Customer Adress“ and different other lists wich hold relational data, like a list Contacts with „Customer Key“, „Contact Name“, „Contact Role“, „Contact Department“.
Now the requirement is to first select all contacts with role „Manager“ and department „Marketing“ and then switch to the central list and get all the cutomers that match the query „Has a contact with role -Manager- in department -Marketing-„.