Can an inline view of Ref_Rows include rows f...

[Jennifer_Clem1]

Can an inline view of Ref_Rows include rows from multiple References to the same table?

For example,

I have a table with a list of events and 3 columns in that table are Attendee 1, Attendee 2, and Attendee 3.

All 3 of these columns are ref type back to a list of people (the same list for all 3 columns).

I would like the detail view for 1 person to display all events they are listed for, no matter what column their name is placed in.

Currently, the system creates a unique table for each referenced column, but I’d like to streamline this to just 1 inline view.

I tried LIST(Ref_Rows(“Events”, “Attendee 1”), Ref_Rows(“Events”, “Attendee 2”), Ref_Rows(“Events”, “Attendee 3”)), but this just returns a list of the key values instead of a list of rows with those key values.