I am guessing that this is a simple question but I am new at CR and haven’t been able to figure it out.

I have a Database that has two separate tables that have almost identical fields of data.

Table1                          Table2

Incident #                    Work Order #

Assigned To                 Assigned To

Incident Type               Work Order

Status                          Status

Open Date                    Open Date

Closed Date                 Closed Date

I would like to combine the data in a report so I can display both incidents and work orders together.  The good news is that the incidents and work orders use different number schemes so having an incident and work order with the same number won’t happen.

Any point in the right direction would be great!

The two tables really don’t relate to each other.  My challenge is we have departments that work on items in the incident table and the work order table.  I am trying to create a view or a report that list “all their work” which would be items from both tables.  If I understand sub reports correctly they are just like hyperlinks to another report correct? 

I was hoping I would be able to combine the two tables in one report but I may not be able to do that.

Thanks for the help