Connected Tables and reporting
Hi, So my company has multiple applications within Quickbase that I have built. I got asked a question today from a manager asking if she could have a report that combines project information from...
Forum Discussion
I don�t have time to post a full reply here but the basic concept is this.
QuickBase can only do a report of a single table. So you need to coax data from your two tables into a single table.
The way to do that would be to set up a third table and then set up a saved a table to table copy which will copy all the records from one table into that third table and then do the same to copy the records from the second table into the third table.
So the idea would beat every time you wanted to do a consolidated report, you would delete all the records in the third table and then re-import from tables one and two.
This could all be combined into a single button to click which would do those three steps in one click.
QuickBase can only do a report of a single table. So you need to coax data from your two tables into a single table.
The way to do that would be to set up a third table and then set up a saved a table to table copy which will copy all the records from one table into that third table and then do the same to copy the records from the second table into the third table.
So the idea would beat every time you wanted to do a consolidated report, you would delete all the records in the third table and then re-import from tables one and two.
This could all be combined into a single button to click which would do those three steps in one click.