Skip to Content
0
Former Member
Sep 14, 2007 at 02:27 AM

Valid Values

917 Views

Good Day

Experts:

We have several User-Defined tables that have fields with Valid Values. On our forms, those fields are defined as it_COMBO_BOX in the CreateForm routine.

Currently those comboboxes get loaded with the Valid Values in the class file typically with the following code:

<b> lStatCombo = MatReqForm.Items.Item("cmbStatus").Specific

lStatCombo.ValidValues.Add("Req", "Requested")

lStatCombo.ValidValues.Add("Conv", "Converted")

lStatCombo.ValidValues.Add("Stop", "Stopped")

lStatCombo.ValidValues.Add("Canc", "Cancelled")</b>

How can I "reference" the Valid Values defined in the User-Table field so I don't have to do it programatically? This will eliminate having to add a Valid Value to the code whenever one is added to the Valid Values in the table.

Thanks,

Ed