Enumlist based with ref reversed Ref

Jonathan_S
Participant V

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?

Solved Solved
0 6 449
1 ACCEPTED SOLUTION

LeventK
Participant V

@Jonathan_S
Try with this:

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

View solution in original post

6 REPLIES 6

LeventK
Participant V

@Jonathan_S
Try with this:

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

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
Thanks!!!

Hi

I have used this and it references correctly but only displays the value in the specific column and not the entire row. I want the display to be the same as the REF_ROWS function but I am Referencing an ENUMLIST with REF base.

For example in your solution above, when I use it, it only displays the value in the [id] column of Table B and I want it to display the entire row with all the columns

Is this possible?

MultiTech
Participant V

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.

Top Labels in this Space