AnsweredAssumed Answered

Condensating Criteria

Question asked by hurstja on Apr 13, 2018
Latest reply on May 3, 2018 by hurstja

The problem I cannot wrap my head around is simple (as always).

 

A Quote contains n Measurements (METING). Each Measurement contains 2 colors, RAL and NCS. Each RAL and each NCS contains 1 out of n color(name).

 

I am trying to establish a table with one record for every unique color in the Quote->Measurement.

 

QUOTE                    METING                    INCREMENT

                                        Color

 

1                              1  

                                        1000                    1000

                                        2000                    2000

                               2

                                        1000

                                        3000                    3000

 

etc.

 

There must be an elegant solution for this.

Outcomes