I would like help with a reference expression for Product Id Column in Sales Returns Details table which is child of Sales Returns table which itself is child table of Orders table. Order Details is another child table of Orders table and not directly related to Sales Returns table.
Sales Returns Details table has reference of the sort ‘is part of’ (of the Sales Returns table)
I would like that the Product Id column in the Sales Returns Details table should show in drop down list only the products against Order Id of the Orders table that were previously sold and are being returned.
What should be the expression for Product Id column in Sales Returns Details table. It is correct uptill the following:
[Sales Returns Id].[Order Id].[Order Details]
It gives error if I add [Product Id] further in the chain above.