Mike,
Formula Queries + pipeline sound just may the solution.
We've something similar where when marking the task as deficient , we run a pipeline parallel which takes the record id of the 'master deficient' task , generated a 'child asset' which has the record id# of the master auto linked via pipeline. We can then use a formula query to do various things with it.
This helps simply , as user doesn't have to do anything. I'm not clear how the same asset is generated in your table.
------------------------------
Prashant Maheshwari
------------------------------
