Great. That works as well. But...I have yet another question and I hope my final question regarding this subject:
With what you gave me, I will have to set the discount 8 different times because I need to pinpoint the specific ID of 8 different items from a particular db. Can I avoid doing all that work and instead tell it to apply the same discount for all 8 items from that particular db without adding that discount to other items that are not from that db?
For example..I add a set of 10 books to the cart and get a 35% discount. That item is not in the db. Then I add a set of 10 DVDs to the cart (reading from the db), and another different set of 10 DVDs to the cart (same db), each getting a 50% discount. I don't want to have to identify each item from the DB repeating the same discount process for all items...instead I want to tell it to apply the same discount to any of the items from the db. I tried using:
'Number of items with a specific column value' combined with the calculation 'Based on items with a specific value'.
It keeps applying the discount to the other item (the book set).
Thanks for all your help.