I think if you're still having the problem... to make things simple, you can update the tables separately, & then doing the SQL statement...
OR you can use SQL statement to do the update as follows: (of course, you could do it with insert)
lcdate = ??
lcgang = ??
lcBlock = ??
lnripe = ??
lngreen = ??
update a set a.ddate=lcdate, a.cgang=lcgang, a.cblock=lcBlock, b.nripe=lnripe, b.ngreen=lngreen from dailyWork a inner join ;
pkg b on a.ncode=b.ncode where a.copr = ("PKG") order by a.ddate
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************