• I think you have the DDL you posted mixed up with what you are after. The FK references BC_Display. Can you please post the table definition for both BC_ShiftSummary and BC_ShiftSummaryInfo, and only the FKs related between those two tables?

    Also, if you were to find multiple rows in BC_ShiftSummaryInfo for the same SS_ID which row should be kept? i.e. what is the criteria? newest per SD_Date?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato