>Thanks Tamar.
>
>I did sys(3054) and received the following:
>
>Rushmore optimization level for table t_memo: none
>Rushmore optimization level for table memo_type: none
>Joining table memo_type and table t_memo using index tag Type_numbe
>
>the first thing that sticks out to me is that the index tag is "type_numbe" and not "type_number". I tried changing the name of the index in the table structure to "type_number", but it is too many letters. however, i thought that the expression is what would be used, and the expression is "type_number". i must be incorrect as the index tag listed by sys(3054) is "type_numbe", but can't seem to change this.

You can't, because Fox keeps tag names 10 characters long. If you've created the tag from the Modify Structure window, it got an automatic name from its expression.

>
>This however still doesn't explain the discrepancy between running the query in vfp8.0 vs. in my app. Then again, maybe that is normal to have a discrepancy like what i showed in my previous message.
>
>Any ideas? Thanks again,

Just a WAG - any difference in the set("exclusive") between your app and the IDE? It could be that you have a local config.fpw which gets loaded with the app, but in IDE you use the one at home(). Check sys(2017) from within the app, where does it point to.