I have a file where in filed1, field2 and field3 are key fields. Now these key fields are not unique, I need to update field 4, 5 and 6 based on the selection by user via subfile.
f1 f2 f3 f4 f5 f6
A0123 A0123A *FILE CLM/D07 D07 1
A0123 A0123A *FILE CLM/D08 D08 2
A0123 A0123A *FILE CLM/D05 D05 1
A0123 A0123A *FILE CLM/D05 D05 2
Now i need to change the 4th record's f6 to 3. Whenever i do Chain its picking 3rd record that is fine by definition of chain, please help me to build logic to update 4th record when user selects option '2' against 4th record and to update 3rd record when user selects '2' against 3rd record. Please help..