using invoice , how do I select from multiple prices?
Using filemaker pro11 and an absolute beginner.
Basically I am trying to set up an invoicing system using the standard template and then modifying it.
I have 4 types of customers and 4 different prices for each product. I have inherited all the customers details in the form of a spreadsheet so I am able to import them into the customers section. The question is how do I first differentiate the customers into their various groups (radio buttons?) and then when making an invoice enable it to select the correct price to be used for the customer i.e retail price or trade price depending on the type of customer. Any help would be appreciated:smileyhappy: