I have two data bases where the fields are exactly the same, only one is Dead Orders and the other is Orders.  I need to run reports that draw data from both reports equally.  Since linked data bases have a "from to" relationship,I have been unable to create any reports as none of the data on either table is "from to" dependent.

 

Also, assuming I can get these data bases to merge, how do I merge the display fields so that one record does not overwrite the other?  As an example how do i get Dead Orders customer name and  Orders customer name to appear in the same column?

 

Thanks for any help offered.