Not sure that will be better but another way is to create a specific Table Occurrence (TO) where the relationship is based on a calculated field (stored) where the formula contains an ExecuteSQL function that gets the foreign keys.
Thus, you are not constraint to use the "only related" value list management built-in option.
By default, an ExecuteSQL returns a list separated by Returns (char. 13) which works fine as a calculated foreign multivaluated key.
Tell me if you need additional information about this.
Additionnaly, if there is definitely a problem with the Drop-down List object, you may replace it by a Portal contained by a Popover, that allow you to add other cool stuff, impossible with a "basic" Drop-down list.
Edit : added some details and fixed traduction bugs.
Are you looking for a drill down type solution where they choose country first then see the list of states etc?
Use magic value lists., but you will need 3, and a regular one for Country.
One for country, Pick one country
This grabs the related values and creates a list of only the states in the country (20?)
Select a state, this creates a list of districts (16?)
Elect district this creates a list of blocks (8?)
Should return a possible list of 75 possible villages...
No one here will expect anything different if you are trying to stuff all 600,000 into a value list, it's mad.
Yes it is a drill down type of list
i'm sorry i didn't get what magic value lists are .. is there something i am missing ?
Thank you Fred , I am relatively new to Filemaker and haven't used the Execute SQL Feature yet , Please let me know if you have any other information on this and how to use it in my current situation.
Do you use this cascade of choices knowing beforehand what you are looking for, i.e. the village name ?
Yes it is a cascade , as the user has to select the appropriate values in each field filtered by his choice in the the preceding field... The user will invariably know the name of the village , but he needs to select it from a list as he may not know the right spelling , capitalizations etc
Thanks , I will try it out
Really Nice , Is there any specific method you used ?
A Popover with merge field.
In the popover there is a slide control.
in the slide control there is a web viewer.
In that there is a custom function that takes your lists
wow . And you don't need three lists side by side.
Very interesting !!!