Do you mean:

select town, fullname, ccode, county from Towns where ... ;
   union ;
select BldMstr.town, space(21) as fullname, ;
       BldMstr.ccode, county from BldMstr ;
       inner join Towns on BldMstr.ccode = Towns.ccode ;
   order by 1  into cursor curTowns

Yes, I think, this would work.

Thank you.

>I would use UNION in the "select..." for RecordSource.
>>Hi everybody,
>>
>>We have towns combobox, which has ControlSource BldMstr.town and RecordSource select town, fullname from towns
>>
>>Suppose, we have entries in a BldMstr table, which are not in Towns table. How can we show them in the combobox?
>>
>>Thanks in advance.