dependent dropdown with image

[tintin007]

Hi Guys,

I have a dependent drop down which adds some values to a table. the meter and sub come from another table called data, Meter and sub work fine. want to add the image next.

Colum 2 =meter 

Colum 3 =Sub

column 4 = Image

I tried to use colum 4 with the same method as meter and sub eg data page[Image] but it doesnt show the image file. the image file is a jpeg link on the matching row for meter and sub. Wanted to be able to show an image of say if the item was a hammer that was selected in the drop down then a hammer image would appear . or if it was a spanner that was selected then a spanner would appear based on the second selected dropdown item.

hope that makes sense to all.

[RBTAndrade · Accepted solution]

Hi @tintin007 , I tested here and it worked with image. If I understood well, you have 2 fields (meter and sub) to match the table data record. If you had a key field to match with table data, you could make a dereference. So, you will need to use a SELECT to get the image field of tabel data, like this: SELECT(TableData[Image],AND([meter]=[_THISROW].[meter],[sub]=[_THISROW].[sub])). Moreover, once SELECT return a list, you need to put an ANY(....) embrancing the SELECT, like this: ANY(SELECT(TableData[Image],AND([meter]=[_THISROW].[meter],[sub]=[_THISROW].[sub]))). but be careful because this can impact processing if the tables are very large.

[tintin007]

Hi @RBTAndrade 

I modified your formula to this one , Which seems to work well. It shows the correct image file in my form. 

It would of taken me a long time to get there. Great to learn new things. Many thanks for your advice.

ANY(SELECT(Data Page[Image],AND([Meter Type]=[_THISROW].[Meter Type],[sub meter]=[_THISROW].[sub meter])))