There has been requests from users like Ted Hughes for automatically filtering picklists based on selection in the previous picklist. This can be done very easily now.
Let us take a Bug Tracker application as an example. This simple application has just three forms.
1. It has a form to fill in the modules. e.g. In the case of Zoho Creator, it could be user interface design, deluge script etc. See a list view of all the modules added.
2. It has a form to fill in the team member details. It has the name of the team member and the module he works for. See a list view of all the team members (and the respective modules).
3. It has a form for filing issues. Each of the issues filed has to be assigned to the appropriate team member. Since we have already defined the person in charge for each of the modules, it will make more sense if the items in the ‘Assigned to’ picklist gets updated every time the module is changed, listing only the relevant entries.