We have an exchange condition to update the tracking reference in shipments.
Our source file has the barcode box reference number and the tracking reference.
We can look up the shipment number from the barcode table brpac903
This is working fine as long as there is only one shipment, but there are often multiple shipments and only the first shipment gets updated.
This is our conditions script - could anyone suggest how we should write this to return all the shipment numbers?
thanks
bob

shpm is the ascii file field name that has the box reference
brpac903.shpm is the whinh430 shipment number
brpac903.shln is the whin430 shipment line number
---------------------------------------------------------------------
table tbrpac903
select brpac903.*
from brpac903
where brpac903.boxn = :shpm
and brpac903.ptyp = 2

selectdo
return(brpac903.shpm)
endselect

return("")

Anyway to include the line in the source file for the exchange scheme?

Thanks for suggestion but that's difficult.
The source file comes from TNT carrier software and there are two fields;
TNT tracking reference
Barcode/Bridgelogix Box reference

bob

Well what I was thinking was if you load it like in a batch job or something - you could take the input flat file and add the line number into it. Then process it through the exchange scheme. Honestly I do not know enough about exchange schemes. I have only done simple ones and nothing too complex. Maybe someone else will see this and have another better suggestion.