By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

issues with reporting foreign keys

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
misscrf wrote:
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.


It sounds like you have a query where there must be a record in each of
the tables. Open up your query and dbl-click on the relationship line
and select the option (either 2 or 3) that selects All records from main
table and those that match in Tablex.

For example. You have the main record and someone entered addresses but
did not fill in any phone numbers. Because of this, that record will
not display if the relationship is set that there must be a matching
record in all tables.
Nov 13 '05 #2

P: n/a
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!
Thanks for responding.

misscrf

It is never too late to become what you could have been ~ George Eliot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

P: n/a
In article <OK*****************@newsread3.news.pas.earthlink. net>
Salad <oi*@vinegar.com> wrote:
misscrf wrote:
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.


It sounds like you have a query where there must be a record in each of
the tables. Open up your query and dbl-click on the relationship line
and select the option (either 2 or 3) that selects All records from main
table and those that match in Tablex.


For example. You have the main record and someone entered addresses but
did not fill in any phone numbers. Because of this, that record will
not display if the relationship is set that there must be a matching
record in all tables.


Things are infinite, the banana clip is a man does it, you drooling
idiot.

--
Lady Chatterly

"Oh, great, Barbie. You're still stuck in that groove, eh? I prefer
even Lady Chatterly to your lame cut and pastes." -- Little Willma







Nov 13 '05 #4

P: n/a

yes, I did that too. Thank you

misscrf

It is never too late to become what you could have been ~ George Eliot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #5

P: n/a
Lady Chatterly wrote:
In article <OK*****************@newsread3.news.pas.earthlink. net>
Salad <oi*@vinegar.com> wrote:
misscrf wrote:
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.
It sounds like you have a query where there must be a record in each of
the tables. Open up your query and dbl-click on the relationship line
and select the option (either 2 or 3) that selects All records from main
table and those that match in Tablex.


For example. You have the main record and someone entered addresses but
did not fill in any phone numbers. Because of this, that record will
not display if the relationship is set that there must be a matching
record in all tables.

Things are infinite, the banana clip is a man does it, you drooling
idiot.

--
Lady Chatterly

"Oh, great, Barbie. You're still stuck in that groove, eh? I prefer
even Lady Chatterly to your lame cut and pastes." -- Little Willma


Snooper.

Salad's not a sexy name and should not be stalked.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.