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?
How can I use the union query in the lookup method
Explain with sample code