cancel
Showing results for 
Search instead for 
Did you mean: 

Referencing the same table multiple times

Former Member
0 Kudos

Dear all,

how can I insert information into a report from a table that is referenced from another table multiple times?

Example:

Assume you have a table where each row has two fields, each containing the ID of a (different) employee. This ID is the key to the employee table that holds the first and last name of the associated employee. Now I want to include in a detail section the first and last names of both employees associated with the row.

How can I accomplish that?

If I just insert the fields for first and last name two times into the report, I always get the information for the employee associated with the field which I have connected to the employee table using the database wizard. However, if I define a second connection to the employee table, I do not receive any values at all.

Many thanks for any advice,

AnDi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Just add the Employee table in again. Crystal will warn you that table already exists but just accept.

Employee table will be added with suffix _1, link this to second Emplyee ID field and then add data to as required.

Ian

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Ian,

it works perfectly.

Regards,

AnDi