Table refuses to link CR8

[mthompso]

I'm trying to link the field "OwnTypeCode" in the OwnershipType table to the field "OwnerShip" in the Sites table.

Both are of type char, one character long.

Crystal 8 refuses to do so. I've tried both visual linking, and doing it in the selection formula.

Any suggestions?

Miles Thompson
CQA Consulting Group
milesthompson@ns.sympatico.ca

 

[BlurredVision]

What database are you using? Brian

http://www.crystalinfo.net

 

[mthompso]

Microsoft Access 97. Should have mentioned that.
No free tables.

This relationship has been mapped and displays in Access's "Show Relationships" view.

Miles Thompson
CQA Consulting
milesthompson@ns.sympatico.ca

 

[BlurredVision]

I have found that adding an indexe to the field I am attempting to link corrects the problem.

Hope this helps Brian

http://www.crystalinfo.net

 

[mthompso]

Brian, that's a good point, but the OwnTypeCode field has always been indexed, primary, no duplicates. This is why it's so hard to believe that Crystal refuses this link.

I shouldn't need an index on the field I'm linking from (Ownership in the Sites table), should I?

Miles Thompson
CQA Consulting Group
milesthompson@ns.sympatico.ca

 

[mthompso]

So, if this field, along with another one now, will not link, how do I include its values? Use and unbound field and try to put a SQL Select statement in it?

Miles Thompson

 

[Guest_imported]

Ya dear friends ,
I have a problem regarding visual linking in crystal report
7.0.
i have two table suppose a1 and a2.
only one attribute is same but length of that attribute
not same.
attributes name are different .
I have problem to link that both tables.
I use oracle as a backend..

 

[mthompso]

Generally you need both field length and attributes the same to link.

What about creating two indexes on fragments of the fields you hope to link on, casting so that they are both of the same type, so that the two tables could link.

Alternately, create a calculated field in the child table which matches the foreign key.

Or, yet again, create a cursor in Oracle and report from that. These may be completely useless suggestions as I've no experience with Oracle.

Regards - Miles Thompson