I am connecting to Oracle thru an ODBC connection and on Crystal V 8.0.
I have three tables: Client, Client_Alerts and Client_Contacts.
There can be many Client_Alerts for one Client, and many Client_Contacts for one Client. Client Id is in all three tables. Client is logically linked to the other two but there is no logical relationship between the other two.
The report is grouped by Client.Client_Id.
For each Client, I want to process all of Client_Alerts and then all of Client_Contacts.
The result should look like:
CLIENT_ID
Data from Client_Alert Record1
Data from Client_Alert Record2
Data from Client_Alert Record..n
Data from Client_Contacts Record1
Data from Client_Contacts Record2
Data from Client_Contacts Record..n
At present, it is looking up Client_Alerts and Client_Contacts at the same time. So the result looks like:
CLIENT_ID
Data from Client_Alert Record1
Data from Client_Contacts Record1
Data from Client_Alert Record2
Data from Client_Contacts Record2
Data from Client_Alert Record..n
Data from Client_Contacts Record..n
Is this a problem with the ODBC driver?
I can see the options I need in the Linking Expert but they are low-lighted ?
Any help is much appreciated.
I have three tables: Client, Client_Alerts and Client_Contacts.
There can be many Client_Alerts for one Client, and many Client_Contacts for one Client. Client Id is in all three tables. Client is logically linked to the other two but there is no logical relationship between the other two.
The report is grouped by Client.Client_Id.
For each Client, I want to process all of Client_Alerts and then all of Client_Contacts.
The result should look like:
CLIENT_ID
Data from Client_Alert Record1
Data from Client_Alert Record2
Data from Client_Alert Record..n
Data from Client_Contacts Record1
Data from Client_Contacts Record2
Data from Client_Contacts Record..n
At present, it is looking up Client_Alerts and Client_Contacts at the same time. So the result looks like:
CLIENT_ID
Data from Client_Alert Record1
Data from Client_Contacts Record1
Data from Client_Alert Record2
Data from Client_Contacts Record2
Data from Client_Alert Record..n
Data from Client_Contacts Record..n
Is this a problem with the ODBC driver?
I can see the options I need in the Linking Expert but they are low-lighted ?
Any help is much appreciated.