How can I display image from another table?

[gioKelly]

How can I display image from another table?

I have table: Country (which contain flags images) Other table: Customer.

in the Customer’s view I would like to show the flag image of the country that customer belongs to.

I am trying with this: LOOKUP(CountryID, Countries, CountryID, Image) and field type as “image” but nothing is shown.

[Phil · Accepted solution]

@Geovany_Kelly

Do you have a Ref field in the Customer table to the Country table?

If you did, you could use a DeReference expression to retrieve the flag image.

[gioKelly]

@Philip_Garrett_Appsh I got it! Thanks for your suggestion, Philip!

[mactiago]

Hello

I'm have a similar solution and tried DeReference but its not working.

I have 2 tables:

Date_Date with Exercise column and a image column.

and a Exercises table with Exercise column and a photo column where there are images.

I want to get these images on Exercises[photo] into Date_Data[image].

I ref the Exercises[Exercise] column and added the dereference on the Date_Data[image] with [exercise].[photo] but I get:

Column exercise in expression '[exercise].[photo]' does not contain a reference

I must be doing something wrong 🙂

thanks for the help.