>Oh Boy, I just had this problem and the way I got it sussed was in the
>form.gotfocus I made it do a seek. Barbara Paltiel put me onto that.
>However in the process of fixing it it was suggested that my parent's
>table name (transact) might not be the smartest so I changed it and all
>references to it. I swear I did nothing else but the need to do the seek
>vanished and I have a lovely grid (well almost but that's another issue)
Yeah. The name where this usually bites people is using "DESC" as an
abbreviation for "Description". :-) It's a good way to crash a SELECT
statement, if you don't realize that in that context, it stands for
"DESCENDING". :-)
The rule of thumb is, if it's blue in the VFP5 text editor (using default
syntax coloring), it shouldn't be a table, variable, or field name.