Report from one-to many relationship

C

CobbR

I have a 3 table databse. Tble "A' is the "master", tble "A" has a one-to-one relationship with "B", tbl "A" has a one-to-many relationship with "C". I have a query that retreves all records in "A" with matching records from "B" (if there are any), and all records from "A" with all records from "C". How do I get a report to print the "A" record followed by the matching records from "B" and "C"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Form involving multiple parents and one child 1
Merging from an Excel file with graphics 1
data merge 0
Extracting a cell value 2
word 2007 mailmerge several forms to one cover letter 2

Top