Associate a value across records in two related tables

[WiscoSippi]

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.

[felipedl]

Hi Benjamin,

You could try something like the attached QVW.

Best regards,

Felipe.