>Hi David,
>The indices are strictly based on columns from the same file. However, when I was playing with the query in order to make it work (I ended up converting it to 3 queries in order to get around the join), I crashed on my UPDATE statement for the APP file.
>
>The error I got was "INDEX does not match the table. DELETE the index file AND recreate the index." Even tho the indices are not illegal, there seems to be something seriously wrong. I never had any problems when using strict VFP update commands (REPLACE or working with controlsources) for the APP table.
>Thanks for your help.
>Shuli
Perhaps you have an index corruption problem. In this case, you have to REINDEX.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)