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

Report to display one to many relation

P: 1
Database Layout:
Table A:
AFieldID
AField1
AField2
AField3

Table B:
BFieldID
BFieldAID (linked to AFieldID in TableA)
BField1
BField2
BField3

There are multiple entries in Table B per main record in Table A.

I cant figure out on my report how to get a list of all the records in Table B associated with each specific record in Table A.

I would like the report output to display each record in A and then the specific records in B. then the next record in A and its specific records in B... etc.

Any help would be appreciated.
Jun 24 '12 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,366
Use an INNER JOIN to join the tables.
Jun 24 '12 #2

100+
P: 759
Use a subreport .
Jun 25 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.