Forum Discussion
Related function doesn't work
Hi fellows, I hope you can help me.
I have the following tables:
As you can see both contain the "Document" column and are related as follows:
I want to extract from the table "DM" the value "DX Date" and place it in the table "BD DTC", but when I try I get the following error: The column 'DM[DATE DX]' does not exist or has no relation to the tables available in the current context.
Any idea what might be going on?
Hi Syndicate_Admin ,
RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE or LOOKUPVALUE.
Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('DM'),"DX",'DM[DATE DX]'),TRUE())Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Syndicate_Admin ,
RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE or LOOKUPVALUE.
Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('DM'),"DX",'DM[DATE DX]'),TRUE())Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.