I have a parent table WorkOrders and a child table Labor. I want to implement a SELECT() for a dropdown to provide a list of Services to choose from. This available list shown needs to be filtered by the Service Type as indicated on the parent record.
Normally to access the parent Service Type field while on the Child record, I would use dereferencing dot notation like this - [Order #].[Service Type].
Additionally, n a SELECT statement, due to scoping, I would normally preface the child column with [_THISROW] in order to access the child value within the SELECT.
But it is not valid to combine these two into a SELECT to get something like:
SELECT(Services[Service ID], [Type] = [_THISROW].[Order #].[Service Type])
I know I can replace [_THISROW].[Order #].[Service Type] with another SELECT (wrapped in an ANY()) in order to access the Service Type field I want and get the SELECT above to work.
However, I am wondering if there some sort of shorthand that would allow using the dot notation in this use case?
Of course, other suggestions are always welcomed!!
LinkedIn
Twitter
