Forum Discussion
Solved
RELATED function not working despite a join
Hi, I have this model: I am trying to create a calculated column to bring in the DealerID from the Clients Table into my Payments Table. But i get an error saying...
Glad that helped!
Yes, LOOKUPVALUE is a good alternative when RELATED doesn’t behave as expected, especially if the relationship setup is tricky. Just make sure the Clients[ClientID] column is unique, so you always get a single match.Happy reporting, and if this solved your issue, please don’t forget to give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit too.
Thanks
Shashi Paul
Ah I see, thanks danextian .
So I will use shashiPaul1570_ suggestion of LOOKUP instead then.
Have you tried LOOKUPVALUE? Did it work? The last time I tested it with a limited relationship, it didn't work.