Advanced Database – bound control properties
Apply, remove bound control properties like: limit to list, distinct values.
Limit to list and distinct values options are only available in MS Access, not Libreoffice Base.
Limit to list changes the properties of a combo box to only allow values from the list.
To do this in Base, you simply need to select the combo box, right click and select Replace with -> List Box
Then enter or link to values in the list box as shown in a previous lesson.