How to Use the Union query in the Look up method

Hi All,

I have a union Query for Combination of two Tables fields .

example Table 1 -field ->ID have 1,2,3

& Table -2 -field ->ID have 4,5,6\

Supoose I run the Query means Its gives 1,2,3,4,5,6 .

How Can I get the Same in the Lookup method?

or

How can I use the union query in the lookup method

Explain with sample code

Thanks

md rhiyas

Since you already know how to use a query in lookup method, I think you’re looking for this.

Union queries don’t work as you think - such a query would have only three fields. You need a join.