I've been working with QB for 4 months now, and I'm trying to work through a possible obstacle. I have two separate tables, Incidents and Investigations. I have built additional suppoting tables to help auto-populate lookups and drive better "Rubik's Cube" analytics of the data (i.e. what service had the most incidents, what cause codes were associated with the incidents and investigations). Here's my process flow:
1) An incident record is opened, given a unique ID, and the data in that form can be associated to a PDF After Action Report that would use Exact Form template.
2) If an incident record requires further investigation, system operators and investigators should click the Add Investigation button, and then populate the Investigation form with additional information.
3) The finalized Investigation record would be composed of data originally pulled from the Incident "form" that could be updated or modified based on the results of the investigation as captured in the Investigation record. The Investigation would then be transferred to an Exact Form template in PDF format for contract purposes.
I've been trying to figure out how to migrate the data from the Incident table into the Investigation table with the least adminsitrative effort. Is there a feature I'm missing in QB that I can leverage for this task? Would I be better off to create a merged table (say, Final Report) that would merge the data from the two tables into the third table?