I am in the process of writing a scheduler for jobs need to be run in the plant....

I use a grdlist, with my first column being a ComboBox.

The combobox's (column 1 of the grid) control source is the a view field. LV_SCHEDULED_ORDERS.cWorkOrderID. The drop down list of the combobox is an SQL statement that finds all cWorkOrderID'S from the WORKORDER table that are not yet "Scheduled".

Each workorder has a status within that table being either :{ "Processed", "Printed","Scheduled","Started"...."Finished",...etc.}.

Once a new workorder is "Scheduled" by selecting it from the Combobox within the grid the respective workorder is updated as such in the WORKORDER TABLE and therefore is automaticalluy removed from the drop down list of the combobox because the SELECT statement is re-run in the GotFocus event of the combobox.

My problem is this. Once a new cWorkOrderID has been removed from the drop down list AND even thought the cWorkorderID has updated in the SCHEDULED_ORDERS table AND is the ControlSource of the ComboBox the text of the ComBoBox does not display it since it is not in the drop down list anymore.

How can I force the correct value of cWorkOrderID IN SCHEDULED_ITEMS view to be displayed regardless if it is the drop down list anymore?????