AnsweredAssumed Answered

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

Question asked by disabled_filcorti on Sep 29, 2015
Latest reply on Sep 30, 2015 by erolst

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

Outcomes