Skip to Content
Former Member
Jul 20, 2007 at 07:10 PM

One to Many relationship in Linking


Post Author: LaurieBorn

CA Forum: Data Integration

I am trying to link three files in Crystal. For every record in the primary file there may be several records in the other two files. I want all of the matching records in the second file, but only want to use the third file for a formula If statement. I did a left outer join to the primary and I did a left outer join from the second to the third file. With my current join I am getting duplicate fields from the second file based on the matching records in the third file. How can I access a record from the Third file to use in my formula without having an impact on how the records are printed from the other files?