0 Replies Latest reply: Jan 27, 2012 5:53 AM by Dietmar Janke RSS

    Assigning grouptext to groupvalue

      Hello QVer,
      I can't find the right searchword which can solve this:
      I have TABLE1:
      G_FIRST  | G_LAST | G_GROUP  | G_GROUPTEXT  |
      A00         | A04        | A00-A04      | A00A04              |
      A15         | A18        | A15-A18      | A15A18              |
      B20         | B24        | B20-B24      | B20B24              |
      B25         | B28        | B25-B28      | B25B28              |          

      The other TABLE2 has all dedicated (from first to last) groupvalues in field (F1).
      A new field (F_GROUPTEXT) in this TABLE2 should assign G_GROUPTEXT to each value corresponding to a group as defined in TABLE1:

      F1   | F_Grouptext |
      A00 | A00A05       |
      A01 | A00A05       |
      A02 | A00A05       |
      A03 | A00A05       |
      A04 | A00A05       |
      A15 | A15A18       |
      A16 | A15A18       |
      A17 | A15A18       |
      A18 | A15A18       |
      B20 | B20B24       |
      B21 | B20B24       |
      B22 | B20B24       |
      B23 | B20B24       |
      B24 | B20B24       |
      and so on.

      Can somebody help me to solve this problem without doing it handmade. Thanks.
      greetings dj_skbs