Is there a way of printing items associated with the mix & match tables. I tried to use crystal reports, but I couldn't find the correct tables. Does any one know how this can be done?
- posted
18 years ago
LISTING OF ITEM IN MIX N MATCH TABLE
Loading thread data ...
- Vote on answer
- posted
18 years ago
You can run this query from SO Admin. If you have several Discount schemes and want to see all of them just remove the WHERE clause from the statement.
SELECT QuantityDiscount.Description, ItemLookupCode, Item.Description FROM Item INNER JOIN QuantityDiscount ON Item.QuantityDiscountID = QuantityDiscount.ID WHERE QuantityDiscount.Description = 'XXX'
XXX is the Description of the Quantity Discount.
Rob