Hello, I've a table calle Customers with a subtable called Customers sheet, inside there are the products a custumer buy regurarly. Sometimes they have a discount on specific product which is written in the costumer sheet subtable.

I've another table called Orders, where i add a date, with a subtable called Ordered product, where i add the product they buy, here a l'ld like to copy the specific discount some customers has on some specific products but if I use the formula Orders.Customer.'Customer sheet'.Discount i get an array with all the discounts the customer has instead of the specific discount on the product inside his customer sheet.
Can you help me? am I missing something? Tks