Detailed view w/ nested table One to many

[chrismiller015]

I'm trying to add a nested table to my detail view.

I have table allEnrollments w/ key productId.  (Accounts have an id [BAC]).

I have table dwcEnrollments w/ key productId. (accounts have an id [BAC]).

When I click on a product record of dwcEnrollments, I want to show a list of allEnrollments products where the bac is the same. (One product ID is tied to a BAC, a BAC has many products)

I have tried to create a ref column, but the related field that is autocreated uses the key of the table. I need instead to use the BAC. So my question is "How do I use a column that is NOT the key of the table to create a nested table on the detailed view?" I have seen some people mention 'use select', but I'm not real sure where I should put that, should it be put in the 'related x' autocreated column?

[chrismiller015 · Accepted solution]

I accidentally solved my own problem. 

in the ref column, instead of REF_ROWS(), I used the following formula 

SELECT(allEnrollments[productid],[_THISROW].[bac]=[bac])