I would approach this with the following Automation Actions.
Detect that a project name has changed (trigger)
Update field in a single record table called automation focus with the all the project name and the new project name.
(the relationship will have been set up to Look up the value of those two fields in Automation Focus into every child record via a relationship back to the single record table automation focus)
Run a saved table to table import which will import child records into themselves, merging on record ID number, Filtered only for the children that have the old project name, and changing just the project name field from the old project name to the new project name.
That is it. Fully automated and the saved table to table imports will run in a second or two even for thousands of records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
