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