Hello, please, I need help with this:

I got this form:

Products (Main form)

ProductName

EAN

Etc

Suppliers (Subform)

SupplierName
Price

In other Form called Orders I got a Lookup of ProductName, in the script of this field I'm trying to get the cheaper supplier of the product and put the values of supplier / price in fields inside Orders form.

Many Thanks.