I have a situation where I need to update multiple records in the Materials table psfrm011 using a one to many relation.

example:
text file looks like this:
fitm|shrk
X|5
Y|6
Z|10

table psfrm011 look like this:
fitm|sitm|shrk
X|A|3
X|B|4
X|C|5
Y|A|1
Y|C|1
Y|E|1
Z|E|2
Z|F|2
Z|F|3

After running import I would like to update all shrinkage percentages for items X, Y and Z:
X|A|5
X|B|5
X|C|5
Y|A|6
Y|C|6
Y|E|6
Z|E|10
Z|F|10
Z|F|10

Is it possible to update multiple records in a table from one record in a text file using exchange?

Any help would be appreciated

thanks

Daniel

Think it will be possible only with a 3 GL code in conditions attached to field relations.