How can I get value from another form based on multiple user input values
Hi all,
I have 2 forms, Material Cost and Quotation forms.
I would like to fetch selling price from Material Cost, which 4 user inputs need to be matched.
e.g. selling price is based on Material, T, W, L all 4 fields in Material Cost are drop down fields.
Please see screenshot in "Material Cost Form"
Here in Quotation form,
I have
Material - lookup field
T, W, L - decimal field
Please see screenshot in "Quotation Form"
How can i fetch the selling price?
Thanks in advance
Mien