I have a template built and I’m struggling with syntax.
I have a orders table and I want to get a list of all of the unique items a customer ordered and then display details of those items from the product table.
In the below it doesn’t recognise [ItemID#].[Name].
I’m assuming you can’t use a select like that in a start function? If not how do I get the unique values?
<<Start: Select(Orders[ItemID#], [Customer] = [_THISROW].[Customer], TRUE)>> <<[ItemID#].[Name]>> <<[ItemID#].[Description]>> <<END>>
Any help would be much appreciated.