Conditional List

[seckinb]

Hello

I have an address list in which I need to choose town and village. 

Every town has different village names.

 

how to choose correct list after choosing the town?

 

thanks

 

 

[jbante]

You could use an ExecuteSQL query to get the correct list of villages for the selected town and use Virtual Value List to show it.

[comment]

how to choose correct list after choosing the town?

 

What you are looking for is called a "conditional value list". There are many threads about it - here's a basic demo:

http://fmforums.com/forum/topic/55459-automatic-zipcode-data-entry-help/#entry261760

 

 

 

You could use an ExecuteSQL query to get the correct list of villages for the selected town and use Virtual Value List to show it.

 

Tsk, tsk.

[seckinb]

the problem, this relationship is not so simple for me.

 

 

http://imgur.com/YTx4VEg

 

 

where I will choose which name is related with which list?

I searched, but cant find the source.