I am in the middle of redesigning my DB in to a separation model. So I made a table only DB and a GUI DB. I imported all my tables from my combined APP in to the new table DB. I then imported all my records. I have 22,500 companies, 18,500 contacts, 9,000 emails. The rest of the 45 tables have varying records from 0 - 500.

My data displays properly in my current combined app. It displays properly in the GUI. But, when I try to access my contact names layout (172 fields) the Tables DB crashes. I thought, perhaps, it was too many fields on one layout so I broke it down into three layouts:

Display Fields (Name, address, etc.)

Container Fields

Global & Calc fields

The container fields show up fine. But then again, most of the records do not contain data in the container fields or the data did not import.

Whenever I try to open the display fields the hour glass shows and it takes about 1 minute to show all fields and all records. If I try to go to another record the crash happens.

I have checked to make sure the indexes on the key fields and name fields are in place. BTW, is there a separate index file?

One must assume there is corrupted data. What is most perplexing is I am not having this problem in the current application or through the GUI on the separation model.

Any ideas, suggestions is appreciated.

It could be file corruption. Save a compressed copy of all the files and test.

Also test with reduced data in the files.

Thanks Vaughn. I'll try it and get back to you.

I've been having bother with indexes recently. They've been causing my FMPro clients to crash on lookups. The only way round this is to close the file on FM Server and run a Recovery on the file.

Doing this seems to cure whatever was causing the problem.

Martyn