Automate discount based on products
I'm quite new to Filemaker and database software in general. I'm in the process of creating a new solution having started with the invoices template in FMP 13.
There are about twenty products. I'm looking for a way to automate a discount when a particular pair of products is added to an invoice. For example, when items 7 and 8 are sold together, they are discounted by £27.50 and when items 11 and 12 are sold together, a discount of £34 is given. I initially thought of adding the two bundles as separate items, but that created stock-management complications as the products are often sold individually as well.
I've added a cash discount field, so it could be done manually, but I'm sure there's a smarter way that I haven't yet thought of.
Any help would be most welcome!