To convert a field to a drop-down (also known as pick-from or look-up table), first go to the table with the field you want to convert and go to Table Management.



Beside the column you wish to convert, click the "Convert to Pick From List" link.



You will get a warning pop-up asking you to confirm the change. Click okay. Once you have converted the field, you will notice a magnifying glass in your table management list and a link to the look-up table.



As always when adding a new column, use the form designer to position the new field in your Detail View/Edit View/Add New View.