Field should display a value according to a script
People order products in sets of 1, 2 or 3 pieces. For each set I have another price (the more they buy, the less they pay).
I entered the specific prices in my "Product"-table layout into the dedicated fields (they are called "set_1", "set_2", "set_3").
I created a table called "Orders". In the "Orders"-layout, I can see whether people purchased a set of 1, 2 or 3 pieces.
But here's the trouble:
I have a field called "Order Amount" in my "Orders"-table layout. How can I tell that field to display the product price (= order amount) that corresponds with the quantity, automatically?
So that, let's say, if I enter "3" into the "Quantity"-field in the "Orders"-layout, FileMaker will automatically and instantly go to the corresponding product, find the price of a set of 3 pieces for that product and display it right there in the "Order Amount"-field?