Associate a value across records in two related tables
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.