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.