FileMaker Pro Advanced 11.0v4 Crashes on selection of item in Drop Down List
Filemaker Pro Advanced 11.0v4 (07-18-2011)
Operating system version
Mac OS X 10.7.2 Lion
Description of the issue
Occasionally (read WAY TOO FREQUENTLY FOR A PRODUCT WITH "PRO" OR "ADVANCED" IN ITS NAME), FMP will crash after I've selected an item from a drop-down list field that is based on a field value list. This is not related to a specific field - it has happened on virtually every drop-down in the DB at one point or other. Many times the DB opens successfully with no errors found during the consistency check. Occasionally not. I've seen a forum post about this sometime or other (can't find it now) and I think the best advice given was to rebuild indices for fields used in value lists. This is not an acceptable solution. This particular DB is > 2.25 GB with 137 tables and thousands of fields and manually rebuilding indices is not practical.
Steps to reproduce the problem
Click a field with a drop-down from a field-based value list. Select an item from the list. The problem is intermittent and happens for me only once every two or three days of heavy data manipulation/data entry.
I would expect the list to be hidden and the field to be populated with the appropriate content, based on the value list.
The list appears correctly. Upon selecting an item, the display hangs for a second or two with the drop-down list still displayed and the item selected, then FMP crashes.
Exact text of any error message(s) that appear
Exact text not available as the screen is not currently displayed. It is the OS X windows saying that an application has "unexpectedly quit."
Nothing particularly special about the configuration. The problem is not new with 11.0v4. It occurred in the same manner in previous 11.x releases.
There is no workaround I have found except not to use field-value list-based drop-downs.