Changing a field value and having it reflected in other tables and keep its relationship
I am new to Filemaker and have a feeling this will be simple to do.
Have 3 tables - Project, Reel and Shot.
Have set up relationships between them all.
Project Name = Reel Project ID = Shot Reel ID
Basically shot can not exist with a reel and a reel can not exist without a project.
Would like it when the field "Project Name" thats in the "Project" table changes, keeps its related records from the "Reel" and "Shot" tables but also update the related fields in the "Reel" and "Shot" tables so I can see the related records still in a portal.
At the moment if I change the Project Name after creating several related records in "Reel" and "Shot" the relationship seems to be severed.
Hope I have explained this well with the correct terminology.
Thanks in advance.