1 Reply Latest reply on Oct 13, 2014 5:13 PM by Wendy Zhou

    One to many relationship showing as '*'

    Robert Gabica

      Hello,

      Is it possible to display the values in the multiple fields.  My example contains

      following two tables Groups and Products.

       

      Groups:

      A, Group A

      B, Group B

      C, Group C

       

      Products

      A, Product 1

      A, Product 2

      B, Product 3

      C, Product 4

       

      The work sheet shows:

       

      Group     Description    Product

      A             Group A         *

      B             Group B         Product 3

      C             Group C         Product 4

       

      Is it possible to have the data show as:

       

      Group     Description    Product

      A             Group A         Product 1

      A             Group A         Product 2

      B             Group B         Product 3

      C             Group C         Product 4

       

      Thanks for your help.  I have attached the Workbook.