a KPSP field: which contains '1' when in this command is a cup.
- a file 'B' with
a PSNR (Key) field: nr of commands
a PSPO field: Positions
a PSAR field: nr of the article
a PSDE field: designation of the article
I would like help to write a script that reads the file 'A' and when the KPSP field contains 1, it lists all the commands and all the positions of the file 'B' associated, in a file 'C'.
Said like that it looks like it's easy but whatever the load resident I do (inner, left, right, inner etc ...), I always find myself with a single line of my table 'B' in my table 'C' (that of course that contains '1') but I would like to see all the positions and items of the order that contains '1'. (if the order contains a cup ('A') which positions of the file 'B' are associated with this command?
(Did the customer buy the saucer and dessert plate that go with this cup?)
