Ordering a ComboBox

[MADSLC]

Alphabetic Combo?

I have created a combo box that draws 3 fields from within the same form/data source. The combo box wants to order the records by its primary key. But I want to order them by [node] as below. Can anyone suggest how I can get this to work?

SELECT DISTINCTROW [T_NNI].[ID], [T_NNI].[NODE], [T_NNI].[FRNNI/FRATM], [T_NNI].[GATEWAY] FROM [T_NNI];

Regards Simon.

 

[JC10001]

SELECT DISTINCTROW [T_NNI].[ID], [T_NNI].[NODE], [T_NNI].[FRNNI/FRATM], [T_NNI].[GATEWAY] FROM [T_NNI] ORDER BY [T_NNI].[NODE];

 

[MADSLC]

THANKS