Hi,

I have 'region' and 'city' fields in my table.

I have defined drop down list for my region field with 14 entries and city with 81 entries. Each region has cities, what I want to do is, after I choose region, only cities in that region should appear in drop down list.

Thank you very much for your help.

This is called a conditional value list. To achieve this, you would need a table that stores the combinations of region and city, a join table.

Here's an FMI explanation: FM Help

Thank you very much for your answer.

At last I did it.

By the way I learned conditional value list