I SET ANSI ON and still go the same results. I also noticd that ORGTRACNUM is not unique. It looks like the bank use it more than once accross days as well as in the same day. It also looks like Bank 1 and Bank 2 may use the same ORGTRACNUM on occassion. I gues the only way to slove this problem is to make a unique fields to work with. I guess Iwould need to add SETTDATE, AMOUNT, ORGTRACNUM and BANKNAME. I could make it a character field. I still think I would have duplicates. In the case of a bank sendning an item that should be two separate orders for say $10 on the same day with the same ORGTRACNUM. What do I do then?
Thanks in advance for your help! :-)
Randall L. Johnson