Display data in a <select> list

Hi, In Lecture “Crash Course”, 10th chapter, we display number aggregations for every department. I want to make some extra, by making a selector that enable me to select a Department. So that, later on, I can use it for eg. listing all unassigned shifts for that department. How can I do that?
1 answers

You have to make a new table, with a relation which has an 1:1 Multiplicity to the displayable data.

In the page view, you have to make a data view that call a microflow. That microflow return the type of your new table.

This way Mendix can even auto-generate the select list.