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.
If it's not broken, fix it until it is.
My Blog