Sometimes, when you collect information with a ‘Database form’ in Moodle, the ‘Add entry’
page shows many ﬁelds. If this includes some non-compulsory ﬁelds, then you can use a dependent menu to reveal relevant ﬁelds only.
For example, to create a form listing all countries, you can use a menu ﬁeld to list the
continents ﬁrst. After the user chooses “Europe”, the selection in Field 2 “Country” is reduced to the countries within Europe.
And, here is the direct link to the Moodle.net entry. Thanks William for sharing such a nice piece of work with whole Moodle community.
If you have some more ideas about using the database activity, please share in the comments.