Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Benjamin,
You could try something like the attached QVW.
Best regards,
Felipe.