>Steve,
>
>That sorta worked.
>
>On the combo box, I have RowSource as:
>
>SELECT RecordId, Desc FROM Inventory ORDER BY Desc INTO CURSOR Temp1
>
>and RowSourceType = 3 (SQL)
>
>When I run the form, I see the RecordId in the combo, not the description.
>But I want the RecordId to be bound to the Orders table ItemId field.
>
>Not sure what I'm doping wrong here
>
>Any ideas?
I have a wild idea: in you RowSource use:
SELECT Desc, RecordID FROM Inventory ORDER BY Desc INTO CURSOR Temp1
(e.g. Desc should be the first).
Also you should know, that you can not use Desc as a field name. It should be Descr at least to not confuse with DESCENDING word in FoxPro. It may be your other problem too...
If it's not broken, fix it until it is.
My Blog