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