Creating a list based on multiple queries (1 Viewer)

[shabbaranks]

Hi,

I have 3 select queries which Im trying to output to a combo - Ive tried a UNION query but I get an error

ODBC-- call failed ODBC Driver SQLBase.....

Firstly is do the results need to match within a union query? I mean they have no relationship what so ever Im just trying to populate this combo with the same results.

Secondly is there a better way to do it? 2 of the select queries query a linked SQL table and the third is a local table. All of the select queries work on their own.

Thanks

 

[Ranman256]

The ODBC-error should have nothing to do with the UNION.
If each query individually works, then put the local and 1 linked table together in a union, see if you still get the error.

and all queries have exact # fields in the union?

 

[shabbaranks]

Strangely enough it now works - bizarre