Crystal Reports - problem displaying informationwith common fields

I'm having a problem getting a particular field to display properly.  There are two tables and her is the issue:

table1.original_original_vendor_id
table1.vendor_to_send

table2.vendor_id
table2.vendor_name

The tables are linked:
table1.original_original_vendor_id ----> table2.vendor_id (full outer join)
table1.vendor_to_send ----> table2.vendor_id (full outer join)

I'm using full outer joins because there is not always data to populate each record.  Sometimes they are blank and that's okay.

The report correctly displays both table1.original_original_vendor_id  and table1.vendor_to_send, but when I drop in table2.vendor_name, nothing is displayed.

How can I get the table2.vendor_name to display when it is linked to both table1.original_original_vendor_id  and table1.vendor_to_send?
GStonerAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You can't unless there are records where both table1.original_original_vendor_id   and table1.vendor_to_send have the same value.

You are linking to 1 record in table2 on a single field.

I think what you want is to add table 2 in twice and link it once to each table1 value.

You end up with 2 copies of table2 table2 and table2_1

Links
table1.original_original_vendor_id ----> table2.vendor_id (full outer join)

table1.vendor_to_send ----> table2_1.vendor_id (full outer join)

mlmcc
0
 
GStonerAuthor Commented:
table1.original_original_vendor_id   and table1.vendor_to_send  do have the same values.

I did not know you could add a table twice as an alias.  I followed that suggestion and liked them separately and the report works fine.

Once again - thank you for your help and quick response.
0
 
GStonerAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for GStoner's comment #a39883406

for the following reason:

See my last comment.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Why accept your comment when my comment answered the issue.

mlmcc
0
 
GStonerAuthor Commented:
I accidentally selected my response instead of the actual solution.  Please cancel the close request so that I can choose the proper accepted answer.  Thanks
0
 
GStonerAuthor Commented:
Thanks for your help.
0
 
mlmccCommented:
No problem.  That is one reason the closure like that has a waiting period.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.