• I would use and IF statement on CASESETTLED to decide which table to join to TBLCASE.

    Far away is close at hand in the images of elsewhere.
    Anon.