I'm trying to create a trigger so that when the field CCTAproject_id in my parent table "tbl_projects" is updated, rows will be created in all of my related tables and given the same CCTAproject_id. I only want this to happen once (due to the way I set up the new submission form, it generates a random string and then the client will update this field once to assign it a new ID number). However, whenever I update any field in that same record in the parent table, it creates another record in the related tables. Ex, I update different fields for one record three different times and three blank c