>Well, you can use a UNION clause in your SELECT. Your SELECT can be as complex as you like - I don't know if there's a limit on the length... maybe 256 characters?
Haven't thought about the limit. You're right, we can not put more than 255 chars in a property sheet.
Anyway, all this research I made not for my application, but for my colleague's. So, I know the solution now and may suggest it.
>>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