I have a table with last name, first name and username. I would like to have the value for the combo box use the user name and the display show lastname, firstname. I changed the SQL code in the business object to include a field called fullname but when I look at options for selecting the BindingSourceDisplay, it only shows me the tables, not the data set I created. I tried creating a view in FoxPro but those do not show on the list either. What do I need to do to make this work?

Thanks.

Nevermind. I figured this out. As long as I don't use the picker, I can use the field name in my query.