Is there a possibility to implement auto-populate fields in Zoho creator.

We have a form, where we are populating some information.

Field1: State

Field2: City

Field3: Area

Field4: Number of boxes

To use this form, I have created Drop down menus for State, City and Area. Based on State, City drop down box will get populated. Based on City, Area drop down box will get populated.

User is not happy, as one city has approximately more than 1000 diff areas. They have to search it from drop down box, which takes time to enter information in the form.

I was thinking of giving it in other way.

State: The moment it start typing the state name, the information will come from database. For example, if user enters K... Karnataka & Kerala should be shown and if user types ka only Karnatak should be shown. User can select it and move to next field.

I know, this can be possible in PHP/JAVA etc... but do not know how to do it in Zoho Creator