on 05-04-2011 11:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ian,
it works perfectly.
Regards,
AnDi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.