I have a multiple-field index in an Access 97 database. It is a setup where one table is the master client registry and the second table is the encounter data. So I have a client with a master ID in the first table with a current encounter number pointer and in the second table I might have a client number with three different encounter numbers. The linking works fine in the Visual Linking Expert of Crystal Reports (version 7) however when I run the report in grabbing all of the data from the secondary table even though the link should be making it pull only the current encounter records from the secondary table. Couldn't find any info on Crystal's site.