AnsweredAssumed Answered

Automate discount based on products

Question asked by violinmike on Sep 14, 2014
Latest reply on Sep 14, 2014 by violinmike


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!