"pretty much anything that involves displaying a list of fields"
How much did you excede with conditional formatting, triggers or GetNthRecord( ) function ?
This is not typical behavior for FileMaker.
Does this happen with any file you create on this computer?
If you move the file to a different computer with FileMaker installed, does it behave the same?
If a newly created from scratch file does not show this behavior, does a recovered copy of your original file show the same slow responses?
raybaudi — minimal or no conditional formatting, no triggers or GetNthRecord. This is (for instance) in the field list you see after File-->Manage-->Database...
PhilModJunk — I will check as you suggest, but it seems to happen with any FMP file when I create it or subsequently modify it.
PhilModJunk — As a start, I recovered a sample 50-field, single table file (a few calculated fields, but nothing special).
The recovered file was significantly better in a File-->Manage-->Database...-->Fields test: the field list was more responsive and did not lock up.
Going back to the original file, the hesitation and locking up were still there.
I will try the files on a different machine tomorrow.
PhilModJunk — Sorry, I'll take that back. The behaviour recovered file is NOT that different from the original after all.
Incidentally, the recovery process did not throw up any problems at all.