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?
>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.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site