Linking Multiple Tables
Posted on 2006-05-15
Crystal Reports 11
I have 3 tables
1st table (Orders) has
Order Number, Customer Number, Employee Number, etc.
2nd Table (Employees) has
Employee Number, Name, Address, etc.
3rd Table (Customers) has
Customer Number, Name, Address, etc.
From Databse Expert, I link the (Orders) Customer Number to (Customers) Customer Number and display the Customer name on the Report
I link the (Orders) Employee Number to (Employees) Employee Number and display the Employee name on the Report.
The report will work fine if i only use only 1 of the 2 fields, Employee Name and Customer Name, but will not display both at the same time.
I get error msg. Failed To Retrieve data from Database. Details: 42000:[SoftVelocity Inc][TopSpeed ODBC Driver][Expected lexical element not found: <identifier> [Database Vendor Code: 10015 ]
P.S. I see that the Customer Number from the (Customers) is indexed with a red flag, also the Employee Number (Employees) is also indexed with a red flag.