>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.
If it's not broken, fix it until it is.
My Blog