How to connect two values in the same form

[RAFFAELE_GOLD]

Hi,

I'm trying to use a value in the form to set another value in the same from and then save the row.

This is the table that starts the form , CATEGORIA is enum type

I'm using a default add button to show the form to create a new row. When the user chooses the CATEGORY for the product in the form I want to set the relative image automatically .

I have a table with two column GATEGORY and IMAGE URL, when user chooses the category with a LOOK UP I find the index of the category to get the link in the column of IMAGE url with the same index 

INDEX(CATEGORIA[IMMAGINI] , LOOKUP([CATEGORIA],"CATEGORIA","CATEGORIA",_RowNumber))

It works but give me always the same index , everytime , always the second item in the column .

The images are in a folder on google drive , I added them like a table but I wasn't able to connect them to category  choice in other way .

Thanks 

     Raffaele

[Steve · Accepted solution]

The problem is described and solution provided in the LOOKUP() doc.

[Steve · Accepted solution]

The problem is described and solution provided in the LOOKUP() doc.

[RAFFAELE_GOLD · Accepted solution]

Another hint? I read the doc but I didn't find the solution.  What should I focus on 

You mean this ? 

INDEX(CATEGORY[IMMAGINI] , LOOKUP([_THISROW].[CATEGORIA],"CATEGORY","CATEGORY",_RowNumber) -1)

Thanks