Merge master and detail into a single table

If I have a master table where each master row matches exactly one detail row (so an N..1 relationship), is it possible to create relationship such that I get a single table where each row combines the master columns and the detail columns.

For example, if I have a list of orders for different products and table O is my orders table and table P is my products table, and each order in O is for exactly one product in P, I want a resulting table where I can say OrdersForProduct.O.Column1, OrdersForProduct.P.Column1.


I don't think you can do this with a relationship, but if I understood correctly, you can do this with a lookup: FlexCel Reports Tag Reference. | FlexCel Studio for VCL and FireMonkey documentation

It would be something like <#lookup(P;ProductId;<#O.ProductId>;Column1)>
If "ProductId" is the field that links both tables.

You could also put this insde a report expression, to name write it in a simpler way, like OrdersForProduct_Column1 = <#lookup...> and then you can write OrdersForProduct_Column1 in the sheet with the data.