I want to UNION 2 tables: projProposalOnAcc and projInvoiceOnAcc such that I have a new table:
I want this so that when I'm in format mapping looking up the document number, I don't need to maintain 2 different tables and I don't need to check if the document is proforma or posted.
Hi Lexicon,
We have the listjoin functionality that can combine different (identical) columns from multiple tables. In addition there is the join functionality where you can define different ways how to join the data (inner/outer).
Have you tried using those functionalities in ER?
Best regards,
Ludwig
Hi,
OOPs, I answered looking at details and not question.. I am not expert on ER so I will wait for others to answer it.
Please check docs.microsoft.com/.../how-to-combine-data-sources-in-a-union-query.
You can create a Union query and View perhaps using this union query if required.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
We are honored to recognize Mansi Soni as our August 2025 Community…
A new season of Super Users has arrived, and we are so grateful for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
