I have a relation to a table, called scaled prices.
in my main table I enter a value for numer of articles. My scaled prices are like below:
0 - 200 pcs. = 30€
201 - 400 pcs. = 28€
401 - 700 pcs. = 27€
I made the relation as follows:
For every typed numer of pieces, I get the correct value for the scaled price of that article.
It works very well for pieces from 0 to 700 pcs. But dont work for values greater than 700.
How can I handle that?
Thanks a lot.