I need some help with accessing columns in Parent/Grandparent records in a select() expression, inside of a <> expression, within a workflow. The thisrow/thisrow-1 expressions aren’t working as I expected.
Workflow on records of Table A
<> expression for records of Table B
SUM(Select( TableC[Amount] , ** ))
Table C is a child table of both A and B, and there is no reference relation between A and B.
I either need to: 1.) do the select() on the child records of Table A (specific records in Table C) -or- 2.) In the select condition, I need to be able to compare a column in Table C, with a column in Table A.
It seems if I do [_THISROW].[col] inside of the <> expressions, it accesses a column in Table A, which doesn’t seem right, I thought I would have to use [_THISROW-1].
So if I try to do #1, I tried :
[_THISROW].[child list][Amount], *)
, which doesn’t work saying "can’t find column ‘child list][Amount’. I’m guessing this is a dereference of a dereference, or is there a different syntax I need to use here? Also tried with a period in between.
For option #2, I’m just wanting to do the same thing, but compare the child’s parent ref column, to the key column of Table A, but I’m not sure how to access a column from Table A from inside the SELECT.
On a side note, “You can’t dereference a dereference”. Why not?