Sorry, "active" is the wrong word. I was trying to simplify.
I have a list of construction projects and sometimes they get split or combined. When split, I'll have two or more new project numbers. These new project numbers may be added to my list or not (I'm only tracking certain projects...