Hi,

I have a very strange problem with a table.

The table only shows 1209 records, and I know the table contains more than 135,000.

The thing is that with a relation I can display all the records in another table.

When I perform a Find in the table it shows the records correctly, but in the status bar displays in example something like this: 25468 / 1209, meaning that the found records are more than the total records.

I tried saving a compressed copy, nothing happens.

I work with FM server 9 and FM pro 8 for the clients in windows.

Any idea on how to solve this will be highly appreciated.

Best regards,

Mauricio

I think FMP 8 has an index corruption issue. Make sure the client is patched to the latest v revision. Try to get them onto FMP 8.5 or later.

I was going to suggest saving a compressed copy. Do it again anyway. :

If it is corrupted index then open the field definitions and tun off all indexes. Close the field definitions. Then turn them back on.

If that fails, do a recover. Do all this on a backup copy.

I'd also download the FMP 10 trial and use it to try to repair the file.

WARNING!!!

Just one unpatched copy of Filemaker 8.0 accessing a file shared with fmserver will corrupt the indexing of a file and that corrupt index will affect all your users. If you have an opening script, I would check the client version in that script and prevent any users with an unpatched 8.0 client from using the file.

Filemaker 8 is one of the most stable versions I have used over the years (as long as it is patched) and would only go to 8.5 if there is some other compelling need to do so. 8 and 8.5 are no longer supported by filemaker.