3 Replies Latest reply on Sep 30, 2015 3:38 AM by erolst

    Change 1 record from 1 file change the same record in the other file

    filcorti

      Hi guys, I know it won't be easy to explain, Im a FM noob I am Italian so... so let's try.

      I have two files, the 1st one: Id call it Source with many records:

      AB
      ORANGEO400
      BLUEB100
      PINKP800

      and I have another file where I can choose with a drop down menu a record from the A column.

      12
      Drop down menu

      If I click drop down menu I can choose Orange Blue or Pink.

      If I choose Blue for example, auomatically inside the column 2, the corresponding value from the source file from colum B appears: B100.

       

      Result:

      12
      BlueB100

      But I have a big problem, the Source file has errors inside it.

      My question is:

      Is there a way so I can change the source file data for example Blue in Blu and B100 in B150 and auomatically the second file changes itself  those values with the new ones?

      Thanks