Hi,
Using Sharepoint online
Problem: I have 3 lists , names are company ,plant and products
company name is using as a look up field in plant and plant name is also using as look up in Product
Solution Required: I want to display company name in product list ( which has no directly link ) how can I display company name in product list ( Note : plant based on company, it means I cannot create link between company and product directly )
image is attached for reference

Thanks


