Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Database Problem

Database Problem

Database Problem

I am trying to link tables by smart key link and I am getting this message (unable to smart link unliked tables,foreign key relationships may not to be present for the tables,or the database not support the retrieval of this information)
and i do not want to smart link key by field names.Please I need help.

RE: Database Problem

I never used CR's smart link but created the links myself..It is not one of CR's best features and requires that the databsse be set up with Primary-->Foreign keys for all the tables.

Just select the fields that you want to use in the join.



To Paraphrase:"The Help you get is proportional to the Help you give.."

RE: Database Problem

As I like to say, Smart Linking isn't smart.  Crystal rarely gets it right.  I have been working in Crystal for @16 years and I ALWAYS build my own links.

To turn off SmartLinking, go to the File menu and select Options (not Report Options!)  Go to the Database tab and turn off Automatic Smart Linking.  This will turn it off for all future new reports.


A computer only does what you actually told it to do - not what you thought you told it to do.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close