I have a head-scratcher here which I haven't been able to figure out. Any help would be appreciated.
I have a small maint. form based on cBizObjMaintenanceForm, to maintain what we call Event Types. On the 2nd (props) page, I have a ComboBoxL called cblCaseType. This ComboBox has it's RowSource Type set to 2 - alias and the RowSource is set to "v_CaseTypeLookup". The lookup view is in my data environment and has 3 columns. The 1st column is for display and the third column is my Bound Column (i.e. the iCaseTypeID). The control source is set to the iCaseTypeID field in the Event table.
This field fills in fine except for when I select the last item in the ComboBox. That record, with a description of "Trial", has an iCaseTypeID of 2 in the CaseType table. But, when I save the Event record, the iCaseTypeID is set to 9?? No other records in the CaseType table have an ID of 9, but it does just happen to be the 9th record in the lookup view in alphabetical order.
TIA,
Jay Robohn
VFP Developer