Enumlist based with ref reversed Ref

AppSheet AppSheet Q&A
1

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?

2

@Jonathan_S
Try with this:

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

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.

[Many-to-Many Relationships](https://community.appsheet.com/t/many-to-many-relationships/37050) Tips & Tricks ?

AppSheet be default supports One-to-many relationships: you have one record (say an Order) that has many related records (order details). But there is another relationship connection type that allows you to connect many records to many records you have a table of records (say Products) where each record can be related to many records in another table (say orders). this means when you look at a product, you can see a bunch of related orders - and when you look at an order, you will see a bu…

4 Likes
4

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?

5

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

6

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

3 Likes
7

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?