Linking an edit box to another edit box with an IF statement
I have made Filemaker to where the customer information (Name, phone #, email, account #, customer type) is on my companies item order sheet and it pops up automatically when you pull their name from the drop down list. I am struggling with linking the box "Customer Type" to the price of the item they need. Customer type includes (Retail, Distributor and Local) and each "type" has different prices. When I select an item to put on the order sheet I want Filemaker to supply the price of the item in the correct category i.e. If I select a dozen doughnuts and the customer is retail then the price = $20. If I select a dozen doughnuts and the customer is local the price = $10 and FM will set the "price box" automatically. I'm thinking an IF statement is appropriate that IF customer type is retail then pull up the record of the object and display the retail price.
(Everything in our inventory has been filed and has all three prices listed so it is easy to pull).
Please help and thank you