Linking tables in Crystal Reports 8.5

[ezamon]

I have been trying to add a second table to my report and I have been having a little trouble as Crystal reports 8.5 does not seem to let you link to a table with out the column in the table being indexed (or primary key added). The only problem with that is the table that I need to link has a few null values in the field. My question, is there anyway around that? I do not have access to change the data in the first table so I cannot add a info to that field.

The first table is the main data table I am using for my report and the second table has the region names that I would like to add to it.
Thanks for the help

 

[IdoMillet]

If you are not using an ODBC connection, switch to ODBC.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Turkbear]

Hi,
What Dataabse?

In most cases if you turn off the automatic linking ( always a good idea) and use the Visual linking tool you can link any field you want to use..
If there may be Nulls or missing data in the right-hand table(s) use a Left Outer Join ( right-click link and choose that option)