>I still don't understand <snip>

two tables

one table receives data every day (WORKPO)

one table stores data for one fiscal year (HISTPO)

WORKPO would have the most updated data

I need to keep track (to produce reports) on what happen

I take a PO # and pull it out of WORKPO into cursor TEMPCUR (so there is all of same PO #)

I compare the other 7 fields with TEMPCUR and HISTPO (in the coding, I pull out the matching PO # out of HISTPO into HISTTEMP so I can mess around with it -via deleting records- without mess up the "live" HISTPO, same for the cursor TEMPCUR)

If all matches, I append data from TEMPCUR to TAB2 ("No Action" table)

If any data in any field did not match, I append data from TEMPCUR to TAB3 ("Changes" table)

This is only for if there is same number of record count on both table (TEMPCUR and HISTPO)