Complex Select/Filter using 3 Data Masters
I have two data masters: Customers and Orders.
Each have an id column.
I have a third datamaster called CustomerOrdersMap, which maps the Orders to Customers like this:
So customer 1 has two orders.
I'd like to update an Orders Data Grid when a customer is selected (e.g. using an input called customerIdInput) as follows (in SQL)
SELECT * FROM Orders WHERE orderid IN (SELECT orderid FROM CustomerOrdersMap WHERE customerid=customerIdInput)
How can I do that using SELECT / FILTER etc?