1 Reply Latest reply on Jul 8, 2010 9:34 AM by philmodjunk

    Unable to add multiple discounts to fields.



      Unable to add multiple discounts to fields.



      I am relatively new to Filemaker 11, I am trying to generate multiple discount fields for different products in the same database.  Currently I am only able to give one discount, however, I wish to add different discounts for different products.

      The system I have done at present only permits me to give a single discount, and when i give the second product a different discount from the drop down selection box it overrides the first discount changing it to the same discount as the second product.

      Any advice, help would be greatly appreciated, as this has been causing lots of problems.




        • 1. Re: Unable to add multiple discounts to fields.

          Your layout shows a series of repeating fields with 24 repetitions. To keep with that design approach, (I strongly recommend you don't), you'd need your discount field to also be a repeating field with 24 repetitions. You'd then need to edit your existing calculation fields to include the new discount field in their expressions.

          I strongly recommend you restructure your database to use a portal to a related table of records for your line item entries on your invoice. The invoice template that comes with filemaker 11 is a decent example of how this is done. (If you don't have filemaker 11, you can download the 30 day trial and get the templates that way.) The resulting system is many times simpler to implement and much more flexible.