Does VFP 6 combo box returns the index number instead of the
field value for datatypes: Integer and Numeric?
Case in point:
1. CustOrder.ID in CustOrder relates to CUSTMaster.ID in CUSTMaster
2. ComboBox1.RowSourceType ="3-SQL Statement"
3. ComboBox1.RowSource = Select CUSTMaster.Name, CUSTMaster.ID from
CUSTMaster order by CUSTMaster.Name into cursor cCUSTMaster
4. ComboBox1.BoundColumn =2
5. ComboBox1.ControlSource =CustOrder.ID
A. If the ID data type is character, ComboBox1 returns the
actual ID data of the CUSTMaster table which is "00001"
ex: CUSTMaster.ID ="00001" .Name ="DEF"
B. If the ID data type is numeric, ComboBox1 returns the index
number of the item in the combolist. In the list "ABC" is
shown first and the index is 2. ComboBox1 returns 2 if "ABC"
is clicked
ex: CUSTMaster.ID =2 .Name ="ABC", .ListIndex =1
CUSTMaster.ID =1 .Name ="DEF" .ListIndex =2
Anybody, please confirm if this is the case.
Thanks, Ramil Alcano 5/31
ramil
~~ learning to stand still