>I usually add a FOR !EOF(tablename) with tablename being the table the values are coming from the make sure that I don't stomp on records that don't have a correlating record in the other table.
>

Thanks for the affirmation ;)

>PS, I like your tag, but true insanity is getting different results each time.
>

Or does getting different results each time lead to insanity? :)

>>e.g. This will update the UpdateMe table from values in SourceTable
>>where the primary keys match.
>>

>>Use SourceTable Order idPK
>>Select 0
>>Use UpdateMe
>>Set Relation To idPK Into SourceTable
>>Replace All field1 With SourceTable.field1, ;
>>            field3 With SourceTable.field2, ;
>>            etc., etc. ;
>>    For !EOF("SourceTable")