issues with reporting foreign keys

[misscrf]

I have a database in 3rd normal form ( or pretty darn close) I have
all of my reports working well, but the main report is having issues.
This is for candidates applying for jobs. This report will come from a
form where the user chooses the candidate that they want to report on.


I have the main report with the candidate information. Then I have a
subform for that candidate's addresses, and one for their phone
numbers. Then I have a subreport for their applications, and I was
advised to put the application's activities in there too. I had
previously kept the activities as a subform in the applications
subform. I had problems with the report breaking on the sub-subform.


Now I am working on a query to bring in the applications and activities
as one subform with grouping.


As I bring in the foreign key tables, I don't get my records. I do not
understand what I am doing wrong. Is there something that I may be
doing wrong? Is there a certain way to execute normalized tables with
many foreign keys into a solid report?
Thank you for any suggestions or help.

 

[misscrf]

I actually found that I did not have all of the joins defined in the relationships. I need to have ALL of them defined. Then I split up the query. I have 1 query for applications, and one for activities. Then I put those together into 1. Now my report is great!