I guess if you change UNION to UNION ALL it should work. Otherwise foxpro internally sorts recors by all fields in the select list to eliminate duplicates.

>Hi everybody,
>
>I have the following code in form.Activate (I hide and activate this form multiple times):
>

>.cmbRegions.rowsource=''	
>		select towns.fullname, towns.Town , towns.ccode ;
>			from towns ;
>			where towns.Town = BldMstr.Town ;
>			union ;
>			select towns.fullname, PostRegn.joiningtwn as Town, towns.ccode ;
>			from PostRegn, towns ;
>			where PostRegn.joiningtwn = towns.Town and PostRegn.Town = BldMstr.Town ;
>			into cursor tRegion
>			
>		.cmbRegions.rowsource='tRegion'
>		.cmbRegions.listindex=1

>
>I want the current BldMstr.town to be the first item in this combo and I want it to be displayed. However, it seems like this cursor sorted somehow differently. Do you see a reason, why the first item in union is not the first selected?
>
>I've just thought about a cure for this problem (add a new sorted field), however, it still seems strange to me.
>
>Thanks in advance.