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