[dcarrill]

I need to create a report that uses both contact information and customer information but I am unsure how to join these tables to collect the information I need. I noticed there is a contact table, a companies table, and a Compantcontactmap table.

I linked the contact_ID field from the contact table with an interjoin to the contact_ID field in the companycontactmap table. Then I linked the Company_ID field in the companies table to the Company_ID field in the Companycontactmap table with an interjoin. When I just add a couple of fields from each table to my report and run it crystal locks up so I must be doing something wrong.

Any advice would be greatly appreciated.

Thanks,
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: Crystal 10, joining tables in crystal with ODBC help please

Are the extra fields custom fields?

[dcarrill]

RE: Crystal 10, joining tables in crystal with ODBC help please

Yes most of what is on the report is custom fields.

[Author]

Posts