I have to create two resident tables
Table 1
field a as key
field b as skey1
field c
field d
The above table has all material numbers
Table 2
field a as key
field b as skey1
field e
So these are two resident table. What I need to do is if the Table 2 Key record exist in table 1,
I want to delete the table 1 record and use the table 2.
So example there are 43 Material records in Table 1
But the join for Table two checks an additional table and if the material does not exit in this table it does not
pick it up and then goes and gets values from additional tables. So my table 2 will have on 25 records.
So I want to delete the 25 records out of Table 1. So my end result is 43 records.
Diane
