Getting discount value of an article based on discounts for families, divisions,etc.

[narcis010]

Hello,

I am building an online catalog and I need to show discounts of products based on the discounts which are set in another table.

Here is how the tables work:

ARTICLES:

DIVISION | FAMILY | SUBFAMILY | ARTICLE | PUBLIC PRICE ARTICLE

DISCOUNTS:

DIVISION | FAMILY | SUBFAMILY | ARTICLE | DISCOUNT VALUE

All articles have a division, family and subfamily. The problem is that discounts can be set by division, family, subfamily and article.

What I need to show is the discount value of each article based on discounts table.

For example, a division might have a global discount for all articles that belong to that category. Then a product of that division might have an especific discount for a family, subfamily or article itself.

The problem is that I have no idea how to show exactly which is the discount of each product.

It is a little difficult to explain it, but any ideas would be really welcome as I've been thinking about it for more than a day and I still don't see any solutions.

Thanks a lot for your help,

Narcís