Link to wiew or ref

[Cynat]

Hello,

i need help for create a view or link
I have  2 tables :
Table 1

• ID
• Product
• Lot

Table 2

• ID
• Made product
• Product_Need (is enumlist of «Product» in a Table 1)

when i’m in a wiew detail Table 2
i need a link to a detail view for each «Product»  in Product_Need row, 

can you help me ?

thanks

[Rafael_ANEIC-PY · Accepted solution]

Hello @Cynat, you can't have multiple links to the rows of table 1 from an enumlist column alone.

For that, you're gonna need a virtual column of the LIST type with the following expression:

FILTER("Table 1",ISNOTBLANK(INTERSECT(LIST([ID]),[_THISROW].[Product_Need])))

That will display an inline view of the selected rows, then, if the user clicks on any of those rows displayed the default behavior is to navigate to their detail view.

[Cynat]

Thanks @Rafael_ANEIC-PY 

it’good