SELE FEDLOG SCAN SELECT V_UPNOMEN *How are the parameters being set? I hope you didn't hard code a reference to FEDLOG into your view. =REQUERY() IF _TALLY = 0 && REcord not found in Nomen table, THEN INSERT IN! INSERT INTO V_UPNOMEN(pk_nom_id, nsn, item_name, item_desc) VALUES (oVar.NextId, oVar.ThisNsn, ALLTRIM(oVar.Item_name), ALLTRIM(oVar.Item_desc)) * You don't need this since you're specifying the alias everywhere. * SELECT v_upNomen ELSE &&RECORD FOUND IN NOMEN TABLE, CHECK IF UPDATES ARE NECESSARY DO CASE *You don't need to alltrim(). It's empty if there are just spaces. CASE EMPTY(V_UPNOMEN.item_desc) REPLACE ITEM_DESC WITH ALLTRIM(UPPER(oVar.Item_Desc)) IN V_UPNOMEN CASE EMPTY(V_UPNOMEN.item_name) REPLACE ITEM_NAME WITH ALLTRIM(UPPER(oVar.Item_Name)) IN V_UPNOMEN ENDCASE endif *You don't need this, just add the alias to the tableupdate. * SELECT v_upNomen =TABLEUPDATE(.T.,v_upNomen) *You don't need this as the data in the record should be *correct since you just updated it, why get it again? * =REQUERY() *You don't need this either. *Scan/Endscan resets to the *correct workarea. * SELECT FEDLOG ENDSCANYou cannot requery once you've changed the record, until you tableupdate/tablerevert.