1 2 Previous Next 24 Replies Latest reply on Jan 22, 2015 1:58 PM by JaredHague

    Problem with HUGE Conditional Value Lists : Is there a more efficient way ?

    binu.alexander

      The fields for my Conditional  Value list are Country >  State > District > Block > Village  

       

      There are 600,000 Villages in all so the possible combinations in the Value lists   is huge .

      ( Countries = 3, States 60 , Districts = 1000 , Blocks = 8000)

       

      It is a drill down type of list where When a Country  is selected  ,  the related States appear,  and so on for Districts , Blocks and Villages

       

      What is happening is the FM Pro 13 Advanced  ( From the  SERVER ) stops responding when I click on the drop down menus .

      Web Direct also crashes when I click on these value lists.

       

      I tried this will fewer records say 1000  and it works perfectly fine.  Other Conditional Value lists with few records work fine.

       

      When the records to be filtered are many ,  FM starts showing the spinning beach ball and then crashes.

       

      I built the conditional value list with   the  method described in the following link from FM Help Page

       

      http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

       

      Is this the most efficient way to built conditional value lists ? 

      OR

      Is that FM can't handle so many records to be filtered through value list ?

       

      I really need to solve this as this is a major issue for a live database that I built recently.

       

       

      Thanks

       

       

      Binu

        1 2 Previous Next