• Thank you! An alternative that may work double duty for some other things I do might be to have a 4th field that flags the children when I build the source table, call that field "ChildDef" for example.

    Can you show me how I could query the sample table and produce a resulting output where any row at a location where there is also an associated "new" ProjectType gets assigned the value of "newChild"?

    Output like this:

    ProjectProjectTypeLocationChildDef

    abc123new111

    abc124222

    abc125new333

    abc126111newChild

    abc127111newChild

    abc128666

    abc129777

    abc1341332

    abc135new1443

    abc136new1554

    abc137new1665

    abc1381776

    abc1391554newChild

    abc1401998

    abc1411554newChild

    abc1422220