Pulling the wrong image

[MEC]

Hi,

I have a table named "Application" with the below columns Ref to another table named "Client":

Client table is where I pull data like address, birthday and etc. I'm trying to pull the profile images in the "Client" table to my "Application" table using the below expression:

ANY(SELECT(Client[Photo], [_THISROW].[Maker name] = [Maker name]))

I can't seem to pull the correct image for an entry. It only captures one image for all Maker entries I make. Anyone knows what I'm doing wrong?

Thanks in advance!

[dbaum · Accepted solution]

---

@MEC wrote:

I'm trying to pull the profile images in the "Client" table to my "Application" table

---

It's unclear what this means. Maybe you're trying to populate a virtual column?

Regardless, you should be able to use Dereference expressions. For example:

[Maker name].[Photo]

[MEC]

Thanks!