LO Base add drop down on form

[APCINTERNET]

Hi

Trying to find out how to add a simple drop-down field on a form so I don’t have to type the same things over and over again.

I have been stuck on this for more than a month and am more than happy to pay for it - if that is an option?

Thanks

Michael

Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win

[Ratslinger]

Hello:

Documentation —

On-line help: LibreOffice Help

Off-Line help (if you installed it): F1 key

Manuals: Documentation/Publications

[Villeroy]

Open the form for editing.
Ctrl+Click the text box.
Right-click > Replace With > Combo box
Source type: SQL
Source: SELECT DISTINCT “column name” FROM “table name” ORDER BY “column name”

A combo box is the same as a text box plus auto-complete. It still allows you to enter any text.