Enumlist based with ref reversed Ref

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?

@Jonathan_S
Try with this:

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

Why would you try this?

Why not use a reference?


Nevermind… enumLIST… gotchu. Many-to-many.

I’ll create a centralized post that answers this, since SO many people try this. Give me a few.


Here ya go, I was surprised at how seemingly easy this was.

4 Likes

Ive Made this work with this,

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

This displays a String of the IDs, How would I show the actual inline views for each of these items in the detail view?

If you include that VC in your column list in your detail view, it should be shown as an inline view.

I have it working now. The base type was of text :slight_smile:
Thanks!!!

3 Likes