Discounts and DiscountsTrigger Tables

[tonygg]

Hi

I am trying to understand how products are linked to discounts in the access DB.

I can see how the triggers are linked to discounts using nDiscountID (in Discount triggers) matching nDiscountID in the Discounts table. The nRewardType in Discounts tells you the type of discount and hence what columns to read in the DiscountTriggers table.

All good so far but I am struggling to connect back to the Product. I can access the Discount group associated with the product using nGroupID from Product to look up DiscountProductGroups at matching with its field nID.

Now on the surface it looks like the nGroupID from Product can also be using in the Discounts table to find the discount for that Product. However that doesn't work. m

Any ideas on how Product and discount are linked?

Many thanks

Tony

[tonygg]

Sorry I realised that I was picking the wrong field in Discounts. I should have used nProductGroup.

I can now link the products to discounts but I cant see a column that shows which discounts are active. I know which ones are in fact active but it doesn't match any columns in the discounts table.

Anyone know which field or fields I need to use to identify active discounts?

Many thanks

Tony