Need to lookup multiple items from another module
I have a module with PO numbers 1 line per PO, with space for 4 product codes
The source list is from a simple PO list, with no details, i can then get the details of shipping etc using a lookup Inbound Stock Transactions.P_Forwarder[LOOKUP: PO] etc
But the source data has mutiple lines, one for each product, which i also need (and the user wishes it to be all on one line)
I want to lookup each item and place the Product code in the 4 columns (as above in blue)
How can i lookup multiple lines from the second module?