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?
Solved! Go to 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! 🙂
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! 🙂