I have a combobox with the following settings:
RowSourceType=3 - SQL Statement
RowSource=SELECT Buildesc, Buil FROM Buil WHERE STR(Buil.Proj,4)=mcproj ORDER BY Buildesc INTO CURSOR cBuilList
BoundColumn=2
BoundTo=.T.
ControlSource=Builinfoview.Buil
What I am trying to do is allow the user to access the combobox items based on Buildesc because the users know the names better than the number. But I want the combobox to show the Building number (Buil). Any ideas? TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.