>I have to restrict the status of loans in a current application and I'm not quite sure the best way to do it. The loans can have a status of "Pending", "Active", "Void" and "Loss". The tricky part is if the loan is currently "Active" the status can be changed to "Void" or "Loss" but not "Pending". The status is stored as cStatus_cId the loan file and uses a comboBox control on the form. Is it possible to filter the combobox based on it's current contents?
BTW, if you have ONLY these 4 values you could use OptionGroup with 4 buttons and enable./disable them depending of current value of the cStatus_cId field.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.