yep that's straight from your example :)

Thought so! =0)

>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.

Right. I guess I wanted to point out though that it wasn't *needed* as you said, depending on how you're updating. If you use the command builder, then yes you need a PK, but not necessarily otherwise.

>I used your two examples as the basis for modifying foxpro data.
>they work great.

Great! I'm glad I could help!

~~Bonnie