Combining Two Lists (1 Viewer)

[chrisrobbo]

How can I combine indentical fields in two tables with a query. To be used in a combo box.

 

[llkhoutx]

Use a union query, that is,

Select AField from TableA
Union
Select AnotherField from TableB;

AField and AnotherField should be of the same data type.

Of course, you can select mutliple fields.