Question Combobox dropdown list values from multiple fields

[karthikcoep]

I want my combobox dropdownlist to show records from two fields, one below the other.
An example will make it clear.

I have two fields each in a different table.
Field 1esktop
Records: HP 112,Dell 325,Hitachi 652
Field 2:Laptops
Records: Dell Inspiron, HP Notebook, Lenova Pad

I want the combobox dropdownlist to display

Dell Inspiron
Dell 325
Hitachi 652
HP 112
HP Notebook
Lenova Pad

Is it possible?How?

 

[pbaldy]

A UNION query:

SELECT...
FROM...
UNION ALL
SELECT...
FROM...

 

[karthikcoep]

Thanks a lot