Hi, so I have two tables:
Table A has a column called Serial No.
Table B has a column called Serial No.
Table B feeds to a calendar, table A feeds to a list-view type of thing.
I want to open up the card from the list-view from table A and have below some “referenced dates” that are from Table B, matching the Serial No.
Using REF_ROW only lets me select the column “TransactionID” from TableA which will not match anything on Table B. I need to do something like REF_ROW but select “Serial No.” from Table A and return the Table B.[Event] that matches Serial No.