I am at a client's office and they are using Crystal Report 7.  I am having a problem getting CR to link more than 3 tables.  It will successfuly link up to 3 tables, but when I add a fourth one, the data willl not show up and the links will not show in the query.  I have four tables:

 

Patient_Status links to Patient on Statuscode

Patient links to Assoc_Client on Patient Number,

Assoc_Client links to Client on Client Number

 

Here is the sql query:

 

SELECT
    Client."ClientNumber", Client."ClientName",
    Assoc_Clients."HospAcctNumber", Assoc_Clients."AdmissionDate", Assoc_Clients."dischargeDate", Assoc_Clients."TotalAmountDue", Assoc_Clients."ReferralDate",
    patient."PatientNumber", patient."FirstName", patient."LastName", patient."SpecialistID", patient."StatusCode", patient."Terminated"
FROM
    { oj ("CTSY2K"."dbo"."Client" Client INNER JOIN "CTSY2K"."dbo"."Assoc_Clients" Assoc_Clients ON
        Client."ClientNumber" = Assoc_Clients."ClientNumber")
     INNER JOIN "CTSY2K"."dbo"."patient" patient ON
        Assoc_Clients."PatientNumber" = patient."PatientNumber"}
WHERE
    (patient."StatusCode" = '33' OR
    patient."StatusCode" = '291' OR
    patient."StatusCode" = '290' OR
    patient."StatusCode" = '289' OR
    patient."StatusCode" = '288' OR
    patient."StatusCode" = '126') AND
    patient."Terminated" = '0'
ORDER BY
    Client."ClientName" ASC

 

It will not show the data from the Patient_Status table, but it will show data from the other three.  Is there a limitation on how many tables you can link in this version?  Can anyone offer a suggestion.  Thanks