1 Reply Latest reply: Mar 22, 2017 4:15 PM by Felip Drechsler RSS

    Associate a value across records in two related tables

    Benjamin Wildmon

      Table A contains some quote and order data. Table B contains some supplemental data. They are related by the SalesDocumentItem key.

       

      Table B will contain three records for every Sales Document, items 20, 21, and 22. Table A only contains item 20. Table A contains the Status field. The Status field only exists for item 20 in the source data.

       

      Is there a way to associate the Status field in Table A for item 20 to Table B items 21 and 22? I'm trying to avoid changing the data model too much as it feeds multiple applications.

       

       

      Capture.JPG