Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ComboxL
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Problem with ComboxL
Miscellaneous
Thread ID:
00264899
Message ID:
00264899
Views:
60
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
Reply
Map
View

Click here to load this message in the networking platform