Solved: Enumlist based with ref reversed Ref - Page 2

Jonathan_S · 12-29-2020 11:12 AM

Good Day All,

I have 2 Tables,

Table A Column [ID] is the Key Column.

Table B – Has a Column of Type Enum List with a base of Ref based on Table A.

In Table A, I’m trying to create my own reverse reference back of Type List to Table B
I’ve Tried This and some variations but to no avail,

Created a Virtual Column of Type List.
Select(Table B, IN([id], SPLIT([Enum List Column],“,”)))

How would one accomplish this?

LeventK

@Jonathan_S
Try with this:

SELECT(
	Table B[id],
	IN(
		[_THISROW].[id],
		[Enumlist Column]
	)