yep that's straight from your example :)
i like using a primary key because it makes the update command straightforward.
you can define which records you wish to update in terms of the primary key.
I used your two examples as the basis for modifying foxpro data.
they work great.

dave.