>I have two tables : Exped and Tasacion
>
>Exped and Tasacion have all two the index Expediente:
>
>Expediente = Anyo + Numexp + Desdobles + Certifica
>
>How I can show all fields of the two tables?
>
>CR85 only show fields for first table.
>
>Regards.
>José Luis.

http://support.crystaldecisions.com/library/kbase/articles/c2009352.asp

Two tables linked on composite index fields only returns data from parent table

The information in the article refers to:
Crystal Reports 8.5


Applies to:

Reported version only
Linking Tables - Composite Index Fields
No data from Child Table
DBEXDRVR.ZIP EID 1363 MHF


Synopsis

In the Crystal Reports Designer, the Xbase database driver (p2bxbse.dll) is used to connect to the Foxpro 2.6 database. A report was then created that links two Foxpro 2.6 tables.

Between the two tables, three links were made on composite index fields. When the report was refreshed, only data from the parent table appeared.


Solution

This issue for Crystal Reports version 8.5 has been assigned the Escalation ID (EID) 1363, and the Track ID 51413.

The fix for this issue is included in the Crystal Decisions Database and Export Monthly Hot Fix (MHF) update, which is available for download by searching for the appropriate language build listed below at: http://support.crystaldecisions.com/downloads

English: search for DBEXDRVR_EN.ZIP
French: search for DBEXDRVR_FR.ZIP
German: search for DBEXDRVR_DE.ZIP
Japanese: search for DBEXDRVR_JP.ZIP

The fix is also included in the Weekly Hot Fix (WHF), which is available for English deployments only at the following location:

ftp://ftp.crystaldecisions.com/outgoing/EHF/DBEXDRVR.ZIP