AnsweredAssumed Answered

Changing a field value and having it reflected in other tables and keep its relationship

Question asked by Pro10Adv on Mar 25, 2009
Latest reply on Mar 25, 2009 by Pro10Adv

Title

Changing a field value and having it reflected in other tables and keep its relationship

Post

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.

Outcomes