Trying to link to a second table in Crystal Reports

[jcook32]

Here is what I have.
I have a report the diplays one record from a sqlserver db. I us a parameter field. In this one record I have several names that I need to display. The names are actually usernames(ex jpcook) I added the table that contains the fname and lname and mi of the user name. Everytime I try to add a field from the second table I get a General SQL Server error. Check message from the sql server. error
What am I doing wrong? I linked the two tables. Why am I getting this error?

joe

 

[Halfcan]

Please post your error.

 

[jcook32]

the error messgase is
General SQL server Error:Check messages from the sql server and next
Error detected by database DLL
These occur when I add a field from the other table. When I remove the field the error goes away.
joe