AnsweredAssumed Answered

calculation in a field

Question asked by keiththirgood on Jan 2, 2011
Latest reply on Jan 3, 2011 by FentonJones


calculation in a field


I'm a complete beginner at Filemaker (I don't even know the terms for the various functions and features). What I'm trying to do is create an inventory of artwork. 

I have a field that has a drop down list of painting sizes. (5 x 7, 8 x 10, etc.)

I created a "table" with the cost of artwork according to size. (I also created a table with the corresponding prices. I even managed to create relationships between the sizes and the prices.

What I want is, when I choose a size from the drop down, the cost field in the record for that piece of art automatically fills in with the cost corresponding to the size.

I can't figure out how to do that.

I've attached a screen shot to show what I think I've done so far. 

I need very careful explanations, as I've very usnsure of the steps to do things and the names of fields, actions, etc.

I'm on a Mac, using Filemaker Pro 9 Advanced.