Jimmy,

Using the VFP help, look up .cdx and .idx, it will give you a decent explanation and will also introducing you to REINDEX(), which is nothing more than part of the maintenance done on tables.


>>>The report runs fine when I'm working on my project, however, I've made an executable of my project, and when I choose a value in the combo and press preview - I get the error "the record is out of range" and no report is generated. (I know the combo value exists in the database) Does anyone have any ideas?
>>
>>Jimmy,
>>
>>Recreate the table indexes, a bad index is the single most common cause of that error.
>
>I'm fairly new to this and my terminology isn't up to par - can you give me a quick example of recreating the table indexes (I'm not clear on what the "table indexes" are)