Linking Tables in Crystal Reports 8.5

[cmetz]

Here is what I am trying to accomplish:
I have two tables, Headers, and Customers
I want to link Origin (in headers) to Customer
ID (in customers) and I also want to link Destination (in headers) to Customer ID (in Customers)
I want to show the customer ID for the
origin and then also for the destination.

Any thoughts?

 

[rogar]

You need to add two instances of the Customers table to your report (menu Database/Add Database To Report). Link Header.Orders->Customers1.CustomerID and Headers.Destination->Customers2.Destination.

 

[konad]

you don't need to add the table 2 times, simply link your origin and destination both to customerid then modify your Crystal SQL statement to say OR instead of AND, and if you need to modify your join from inner to say LEFT OUTER depending how you want your records returned if there is a match or not. let me know if you need help

 

[rogar]

konad,
Your solution will return the Origin CustomerID and Destination CustomerID in two separate records, if they are different. My two-table solution will get the Origin CustomerID and Destination CustomerID in the same record.