Conditional multiple select

[Belgana_France]

Hello,
I would like to had a record depending of a cell from a link.
I Explain myself
The result in “field 12”
“Product 1” is a link to an other table
“Unit cost” and “in stock” are colomn from the other table depending of “product 1”

I would like to display in field 12 only the first product in stock.

Thx

[Justin_Barrett]

Is this related to the other thread where you’re asking to only see certain items in stock? It feels similar, but I’m not sure that I understand this scenario from what you’ve described so far.

[Belgana_France]

Yes, I tried various thing. The last one is the closest of what I want