AnsweredAssumed Answered

Get a value from a related table, that dont match relation

Question asked by tanja on Aug 29, 2018
Latest reply on Aug 30, 2018 by tanja

Hi,

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:

Screenshot at Aug. 29 23-28-02.png

 

 

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.

 

Tanja

Outcomes