Relate Syntax

[FredericForest]

Hi guys,

I'm trying to wrap my head around using the Relate() function in a one to many relationship and I'm just not managing it. I've exhausted just about every combination I can think about, and still no luck. 
For what I'm getting, I should be doing something like : 

Relate(
   TableManyRecord.LookupColumn
   ,TableOneRecord
)

As an exemple, I have a Product table with a lookup field called LOOK_Category to a categories table. I'm trying the most basic version (and about every other combination I can think about) and still no luck.
Relate(
    First(Product).LOOK_Category
    ,First(Category)
)

I'm on Dataverse For Teams by the way. Anyone knows where I'm going wrong?

[HFG · Accepted solution]

Hi @FredericForest , 

I believe you need to add the name of the other table in your code. Something like: Relate(First(Category).Product, 
    First(Product)
)

Hope that helps! 🙂