Can anyone tell me if there's an quicker way than what is currently coded? Is it necessary to update teh view before I continue processing? or can i just cotninue to add records and update the table once the process i complete?

sele fedlog

SCAN
SELECT V_UPNOMEN
=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))
SELECT v_upNomen
ELSE &&RECORD FOUND IN NOMEN TABLE, CHECK IF UPDATES ARE NECESSARY
DO CASE
CASE EMPTY(ALLTRIM(V_UPNOMEN.item_desc))
REPLACE V_UPNOMEN.ITEM_DESC WITH ALLTRIM(UPPER(oVar.Item_Desc))

cASE EMPTY(ALLTRIM(V_UPNOMEN.item_name))
REPLACE V_UPNOMEN.ITEM_NAME WITH ALLTRIM(UPPER(oVar.Item_Name))
ENDCASE
endif
SELECT v_upNomen
=TABLEUPDATE(.T.)
=REQUERY()

SELECT FEDLOG
ENDSCAN