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.