2 Replies Latest reply on Mar 25, 2009 4:16 AM by Pro10Adv

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

    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.