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
Is this the most efficient way to built conditional value lists ?
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.