9 Replies Latest reply on Feb 27, 2017 8:50 AM by philmodjunk

    How to script to replace specific field for all related records?

    jiang_aq

      I'm a newbie, just begin to learn filemaker these days.

       

      Example like this:

       

      Table:

       

        Field1    Field2   

      1 aaa         123

      2 aaa         413

      3 bbb         555

      4 ccc         222

      5 ccc         234

      6 ddd        294

       

       

      My current record is 5th, when I modify Field2 value from 234 to 888, then I

      I wanna replace all ccc records's Fields2 with 888,

      after substitute, locate back to my 5th record.

       

      How can I script it? Thank you!