>Hi Naomi,
>
>Thanks for the code. However, MfgName and MfgNum is only in crsMPM, but not in crsData. Is there a way to insert it to crsData? All the PartNum in crsMPM are in crsData and more.
>
>Thanks in advance.
>Sam

Reverse my select statement, then. E.g. start from crsData and do a left join with crsMPM. You can select into the same cursor name, or you can select into temp cursor, then zap the original and append from the temp.