Oh my word. I can't believe I missed that!!! Dang nab it! If you feel you must use the alias, you have to use the one for the target table. DARN! I should have looked more carefully.
>>Let's try for the simpliest answer first: have you checked that there are really at least one record in Workpo that have Code = "1"?
>>
>>>SELECT workpo
>>>*blah blah blah
>>>SELECT histpo
>>>APPEND FROM workpo FOR workpo.code = "1"
>>>
>>>then I look in histpo, there is nothing...
>
>APPEND FROM workpo FOR code = "1"
>
>When Fox evaluates the conditions in an Append From statements, it first appends the record, and then checks it's validity, and then discards it or keeps it. Using the alias of the source table actually confuses it - you don't know which record it thinks about (i.e. what's the current record in WorkPO that the filter applies to).
--Todd Sherman
-Wake Up! Smell the Coffee!