Slices across tables with refs - cannot get them to work

[kacoroski]

I have two tables - a table of cafes with name, address, etc. and a table of reviews that with the name of the cafe and metrics on the cafe. So far so good. One metric is what the cafe is best for which is a EnumList of {Hangout, Group Study, Solo Study, All}. What I want is a slice that contains all the Cafes with metric [Best For] = Hangout. Normally I would do a select distinct on the reviews table, but for the life of me I cannot figure out how to do it in appsheet. I have tried select, contains, etc. and the best I can get is all the reviews for the cafes that have [Best For] = Hangout. I do not want all the reviews, I just want the cafe name so I can put it into a form called Hangouts that will list all the cafes that are good for Hangout. Once I get this figured out I can do the other Best For values the same way.

Thanks in advance

ski