Hi everyone,
I started working with Queries recently and got this request form a user. They want to do a union between two unrelated tables (Example Customer and Vendor).
From what I have read there is no Union function in BC Queries.
To get the output on the image I created a new table called "Source" with Source Type, Source_No and Source_Name as the fields.
In the OnBeforeOpen trigger in the Query I did the following to insert lines into the new "Source" Table. In other words the "Source" Table get recreated every time the Query is opened.
Now I get the results that I wanted but I'm wondering if there is a better more effective way to do this?
Thank you in advance
