AnsweredAssumed Answered

Field should display a value according to a script

Question asked by PatrickHolzer on Jan 29, 2009
Latest reply on Jan 29, 2009 by PatrickHolzer

Title

Field should display a value according to a script

Post

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?

Outcomes