Calculation Based on Item in Value List
I have an invoice type of layout in Filemaker 11 Pro. I want to create an auto entry number in a field called "Total Line one". This would be dependant upon a specific value (i.e. DVD) in a drop down list being selected in my "order type 1" field. I then want to enter a quantity number in the "quantity 1" field. When "DVD" is selected I want a calculation of $8.00 x "quantity 1" to show up in the "total line one" field. I want to set this up for all items in the drop down list to reflect different prices for the item selected.
If "CD" is selected, I want the "totalline one" field to enter the total value of $5.00 x "quantity 1"
If "DVD" is selected I want the "total line one" field to enter the total value of $8.00 x "quantity 1"
If "MP3" is selected I want the "total line one" field to the enter total value of $3.00 x "quantity 1"
Can this be done?