>Your error from the Union of the two memo fields most likely is due to different Memo Blocksizes for the two tables. If you get a chance, would you check this theory. Thanks.

Nope. The error is generated because UNION requires VFP to do DISTINCT on the records in the result set but VFP doesn't compare MEMO/GENERAL fields in DISTINCT operation and there are no other fields to compare. In VFP8 you cannot include Memo/General fields in UNION select even with other fields.