if u know the layout of destination.txt, you can create a blank structrue and say
- use destination
- appe from desitnation.txt sdf
or u can open destination.txt in excel and save it as dbf.
then u can match product and destination to get a 3rd file
sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf
your prddest.dbf will have all product codes with destination,description and group