Click on the menu System > Maintain Lookups
Then click on the ADD button at the side of the list of tables to add a new table and when prompted enter a new name i.e. COUNTRY:
Then click on the menu System > Maintain Tables.
Select the table which you want the new lookup to be associated with and click on the ‘Modify’ button. This example is using TMSEMP:
You will need to add a new entry for ‘Country’ at the foot of the table as shown below, when you are done you will need to click the ADV button for the advanced options.
Then select COUNTRY as the lookup which you created earlier. If you wish to maintain the history of the field then change this from ‘N’ to ‘Y’. You can also set a default value (used by the lookup code) for the field within the Default section.
Once you have entered the screen below, click the Add button to add the new field:
You will need to select Edit as the type and click on OK.
Then select the Table and Field name as shown below:
The field properties should be the following:
When you click OK your new field will be added to the top of the panel as a white square with a black border. Select the field and drag it into a more convenient place on the panel and click on OK:
Then close the Maintain Panel section and exit out of the DBDEF application.
You can now enter the items you want in the list by click on the ‘Modify’ button, then entering the relevant code information and clicking on the ‘Apply’ button.