Report Using Multiple Tables
Hi Everyone, Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on ...
Forum Discussion
Can you give more detail on how to set up the automation to daily copy of records from each table (4 or more tables) into this mater table?
I and also how to creat new key that prefaces each table's name with the record_id's.
------------------------------
Kevin Elliott
------------------------------
I and also how to creat new key that prefaces each table's name with the record_id's.
------------------------------
Kevin Elliott
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou would make a field called [Consolidated Table Key] on each of the 4 tables like
"T1-" & ToText([Record ID#])
Then set up a saved table to table copy (ie a saved Import under the import/export) option to copy the records from Table 1 to the Consolidated table and map the [Consolidated Table Key] field into the Key field of the consolidated table.
Then repeat for each of the other three tables.
Then set up an Automation to run each night to run the saved table to table imports.
There should also be a process to delete any records in the consolidated table if the source record was deleted.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
"T1-" & ToText([Record ID#])
Then set up a saved table to table copy (ie a saved Import under the import/export) option to copy the records from Table 1 to the Consolidated table and map the [Consolidated Table Key] field into the Key field of the consolidated table.
Then repeat for each of the other three tables.
Then set up an Automation to run each night to run the saved table to table imports.
There should also be a process to delete any records in the consolidated table if the source record was deleted.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------