Getting Single Report from Two Child Tables
in my parent table (Bank account) debits are coming from Bill Payment Table and credits are coming from Invoices payments receive table. Currently i am getting two separate reports for debits and ...
Forum Discussion
Thank you for quick response. I also thought about the third table which includes records from both the tables. Using pipeline When ever we add record in either of the table, we will add record in the third table by copying the original data. I hope that works fine.
------------------------------
Ravi Siddana
------------------------------
Your other option is a reporting tool like PowerBI or Tableau. They are not as friendly as a QB report but they are much more powerful and will let you build a report from as many tables as you wish.
------------------------------
Don Larson
------------------------------