Reports Pulling Data from 2 Tables at once

I have an idea for this!  1) Create a 3rd table where both table can be combined.  Run a pipeline job to insert all data from the external table to the new table and another step to insert all data from the internal table to the new table.   2) Once this is done and the new table has all the data, add a Quickbase action in both tables that,  when a new project is added to either table,  will copy the new project to your 3rd new table.  

Or if you didn't want to use a pipeline, you could export both tables to excel and import both to the new table.  Then continue updating with the Quickbase actions. 

You now have a table with all projects for which you can create a report.

------------------------------
Barbara Alvarez
------------------------------