I want to pull data from two totally different databases. One is an Access DB and the other is an Informix DB. There are no common fields to link together in the Database Expert, however in the Informix DB there are some agent numbers. These agent numbers relate to a field called eOriginator in the Access DB...as shown below..
Agent number = 1364 (which is Joe Bloggs)
eOriginator = Joe Bloggs
Is there a way of telling Crystal Reports XI that Agent Number in Informix DB is the same as eOriginator in the Access DB? Basically i want to link Agent 1364 to eOriginator (both of which are equal to Joe Bloggs)