>>>I never seem to quite figure out how to make combo boxes work the way I want, so here it goes again. I have a client table with a ssn field for the employee servicing them. I also have an employee table with lastname, firstname, ssn. I want a dropdown combo box that displays lastname, firstname but saves the ssn to the client table. I have attempted to create a cursor with 2 fields, lastname, firstname and ssn. Set the ControlSource to client.employeessn, set RowSource to employee.name, set the columncount to 2, the BoundColumn to 2, the ColumnWidth to "225,0", RowSourceType to Alias, DisplayValue to emplyee.name. Still doesn't save the correct data to the client table. Any suggestions? What am I missing? Thanks,
>>>
>>>Shane
>>
>>Hello Shane
>>try setting the combo property BoundTo to .t.
>>
>>Regards
>>
>>Pete Kane
>
>Using VFP 3.0 and can't find BoundTo only BoundColumn
>
>Shane

I changed it to a Type SQL and changed some other properties and got it to work. I also found some extra code that the previous programmer had added that was screwing things up. THanks for the suggestion.

Shane