>I need to mark something (1,2,3,4) for reports (I think it is the easiest). All I need is to learn how to compair side-by-side with dupe records. First, I get the PO (a field) from WORKPO and see if there is an existing PO in the HISTPO, I need to check if it is the same (if same, mark it "2" for "no action") or updated (if different, mark it "3" for "changed"). If there is none existing PO in the HISTPO, it is a new PO (mark it "1" for "new transaction").
So, are you having problems doing this? If so, what exactly are you having a problem with?
>The other thing is sometime there can be 4 existing PO (4 records) in HISTPO and new 6 PO (matched with the 4 PO) in the WORKPO (that would be marked as "3"), I need to REMOVE those 4 records out of HISTPO and add the new 6 PO into the HISTPO.
Okay, are you having a problem with this? Maybe it is me, but I don't find your questions to be very clear.
>Boy, I have to get this done by next week and I am confused already! Another way is I could copy out records and do temp matching and go back to the WORKPO and mark them??????
Joseph C. Kempel
Systems Analyst/Programmer
JNC