Select SomeField from TableA into cursor crsTemp NoFilter
select TableB
append from dbf('crsTemp')

>How can I append one individual fields of records from one table to another? If both tables contain names and dates that are exactly the same but I want to insert the only data from TableA.field1 into TableB.field1
>I am trying the following code but need help!
>
>SELECT TableA.amount ;
>APPEND FROM TableA ;
>WHERE TableA.somedate = TableB.somedate
>
>Thank you!
>Max