Hello,

I have a combo box that has as a rowsource and alias of a table. This much seems to be working ok, since when I run the program I can click on the combo box and have fields from the table come up. The problem is that the wrong field is showing.

The table has the following fields: client_num, loc, type. Client_num comes up in the combo box, I'm assuming because it's the first one. I want just loc to come up.

How do I tell FoxPro which field I want to appear in the combo box?

Thanks,