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:
and I have another file where I can choose with a drop down menu a record from the A column.
|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.
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?