Query that references a field ID(P_K) to filter data from other ta



I'm trying to build a query for printing a report that pulls data from other
tables. The Parent table uses an ID P_K that is unique however the other
tables will use this ID as reference only. A Child table may have several
refernces that match the parent ID. I would like all the records I have
chosen from the child tables to show in the report...Of course the Parent
tabe ID would only have one record but the data pulled from the child tables
with the matching field may have several records. Can this be done?

Duane Hookom

Yes. You quite often group by the parent table and place its fields in the
group header section. Limit the detail section to the child records.

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