Shameless Disclaimer: I am fairly new to Infopath, so detailed help
would be greatly appreciated.

Quick View at my Data Source:

RESOURCE:
 Resource Name (Drop-Down / Repeating Table)
  JOB: (Repeating Subtable of Resource)
    Job Notes
    Job Type
    Job Client
    Job Project

I have saved the above template into Sharepoint for Project Managers to
fill out. They fill these out with the resources they are going use.
Any certain resource has the ability to work on multiple jobs.
Additionally PM's are able to use the same bucket of resources. Here is
a sample of what the data looks like when I open one of the PM's files:

Project Manager 1
Resource A
 Job 1
 Job 2

Resource B
 Job 3
 Job 4

My goal is to use the Merge functionality to merge all of the forms
into one report. However when I try to merge more than one form I get
the following result:

Resource A
 Job 1
 Job 2

Resource B
 Job 3
 Job 4

Resource A (from Second PM's form)
  Job 5

Resource B  (from Second PM's form)
  Job 6

What I would like to happen is the select of Resource A then review
both PM 1 and PM 2 jobs for Resource A and display the appropriate
corresponding jobs. Such as:

Resource A
 Job 1 (from PM 1)
 Job 2 (from PM 1)
 Job 5 (from PM 2)

Resource B
 Job 3 (from PM 1)
 Job 6 (from PM 2)

What is the easiest and best way of accomplishing this? One would think
this would be pretty straight-forward, however I see a "custom merge"
template in my near future. I have not seen any decent how-to's for
dummies on that.

Any and all help would be greatly appreciated!