I have two tables Builds and Orders.
Both have a common field Order ID
I want to display, in a view, data from both tables. My view has Builds with a lookup to Orders.
What is the syntax so I can join the two tables and see the details from Orders that match the Builds.OrderID.
So it should be equivalent to Orders.OrderId = Builds.OrderId
I assume its a filter but where do I put the formula and what is it?