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 :
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?