
CLOSE DATABASES ALL

USE (YEAR_PATH) + "ITEMMAST" EXCLUSIVE
SELECT ITEMMAST
ZAP
APPEND FROM ALLT(MPROG_PATH) + "\HHMLYEARSTRU\ITEMMAST"

USE (YEAR_PATH) + "MODEL" EXCLUSIVE
SELECT MODEL
ZAP
APPEND FROM  ALLT(MPROG_PATH) + "\HHMLYEARSTRU\MODEL"

USE (YEAR_PATH) + "MODELCOL" EXCLUSIVE
SELECT MODELCOL
ZAP
APPEND FROM  ALLT(MPROG_PATH) + "\HHMLYEARSTRU\MODELCOL"

USE (YEAR_PATH) + "FREESERV" EXCLUSIVE
SELECT FREESERV
ZAP
APPEND FROM  ALLT(MPROG_PATH) + "\HHMLYEARSTRU\FREESERV"

DO OPENFILE