URL from an other table

[Florian_STEVANC]

Dear all,

I need your help to solve my problem, I’ve been looking in many posts but I can’t get my app working.

I have an inventory table called INV in which I have ID_EQUIPEMENT (text, Key and label) and URL (text)

I use a form to add a line in QFQ table (it is basically a log table), with ID_EQUIPEMENT (text) is to be filled and a virtual column URL (url) in which I would like to get the value of the URL in INV based on the ID_EQUIPEMENT entered.

here is the virtual column (url) formula in QFQ table that gives no error but does not work :

hyperlink(encodeurl(unique(SELECT(INV[URL], ([_THISROW] = [ID_EQUIPEMENT])))),‘link’)

Two problems:
-I can’t use _THISROW because I means that ID_EQUIPEMENT is the KEY, and I may have the same ID_EQUIPEMENT many times in the QFQ table since it’s a log table.
-Second problem, my formula does’t give me a url result that I could use in an action.

thanks a lot for your help, I’m totaly stuck…