Populating the combo-box list

There is a Status field on the Discussion Detail tab. Currently, this field accepts free text. For various practical reasons, such as, to maintain the consistency in communication, to support project guidelines, to have clean data for further analysis and reporting, and so on, it makes sense to convert the Status field into a combo-box and the possible values are listed for the user selection. In this recipe, we will follow the steps to convert the Status field into a combo-box and configure it in such a way that it is populated with values.

Getting ready

Drop the status column by executing the following SQL:

ALTER TABLE c_mom_discussionline DROP COLUMN status;

How to do it...

1. 1. Create a new table, c_momstatus, to capture the list of status values by executing the following SQL:

   CREATE TABLE adempiere.c_momstatus
   (
   c_momstatus_id numeric(10) NOT NULL,
   ad_client_id numeric(10) NOT NULL,
   ad_org_id numeric(10) NOT NULL,
   isactive character(1) NOT NULL DEFAULT 'Y':...