Two different tables linked to same table...need help

[Santos]

Hi everyone,

I have a problem here that I can't seem to figure out. Basically, I have four tables (Candidate, Offers, Interviews, and Status)

The candidate table is linked to both the offer and interview tables. Both the offer and and interview tables are linked to the status table.

What I want is for the report to show the status (offer given out and interviews held) for all the candidates, from BOTH the interview status and offer status tables. My problem is that currently, the report lists either one or the other but never both. I've tried playing around with the links but still had no luck. Any suggestions?

 

[balves]

Add the Status table a second time to the report. You'll first get a confirmation message from Crystal.

By default, the name of the second instance of the table will be Status_1.

Link the Offer table to one instance of the Status table and link the Interview table to the other instance. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer