1 Reply Latest reply on Jan 3, 2015 3:44 PM by philmodjunk

    Using drop down lists on existing file causes Filemaker Pro to crash

    JudyMasters

      Summary

      Using drop down lists on existing file causes Filemaker Pro to crash

      Product

      FileMaker Pro

      Version

      11

      Operating system version

      Mac OS 10.10.1

      Description of the issue

      I'm using a small database, used for years, where I have drop down menus and suddenly when I use the drop down menus the database freezes and the software quits. I've only noticed this since upgrading to Mac OS 10.10.1.

      Steps to reproduce the problem

      I made a copy (compacted) of the file and used this new file and the problem has continued to occur. I've gone into layout and just changed the fields to text fields and that solves the problem but because the data is repeated, it is easier to use the drop down menus.

      Expected result

      It has worked for years without problem.

      Actual result

      I now have a problem in that using the fields with the drop down menus causes the software to crash. It is a small file - only 223kb

      Exact text of any error message(s) that appear

      No message, software quits

      Configuration information

      The upgrade to the new Mac OS??

      Workaround

      Workaround is to change the fields to an edit box. If you have a look at the screen shot I had all the teams in a drop down menu and the possible selections e.g. home, away, draw but I am now just having to enter the data manually because using the drop down menu causes the software to quit after just a couple of entries.

      Screen_Shot_2015-01-02_at_10.02.13_am.png

        • 1. Re: Using drop down lists on existing file causes Filemaker Pro to crash
          philmodjunk

          I suggest recovering the file and testing the recovered copy. If the recovered copy works OK, It's possible that you have a corrupted index as that could be something that your drop down list is interacting with if this is a "use values from field" value list. So if the recovered copy does not crash, try recovering the original file, but use advanced recover options with the options "Copy File Blocks As IS" and "rebuilt index now" as the only specified options. This is a much less drastic recover that only rebuilds your file's indexes--leaving all other parts of your file unchanged.