A master-detail query is an outer join. It is useful when you want to include ALL records in the master query regardless of whether there are matching records in the detail query or not.
1. On a blank report page, drag in a new list item (Master). Populate it as needed.
2. Drag in a new list item (Detail) and drop it into one of the columns of the Master list. Populate this list as needed. One of these fields (ID) must be related to an associated field in the Master list to link the two queries. This step must be done correctly to allow Detail to be an available selection in Step 5 below.
3. On the Menu Bar, select Data > Master/Detail Relationships
4. Select Master in the top listbox.
5. Add Detail as a filtered query and set Master.ID=Detail.ID. If Detail is not shown as an available detail query selection, then double-check that you performed Step 1 correctly.
6. Run your report.
Some further notes: You can add multiple detail queries to a single master query. You can enhance the appearance of the report by hiding the detail query list headers as desired.
Subscribe to:
Post Comments (Atom)
Master Detail Relationship explained well
ReplyDeleteI have a question, if I have a report with 2 master detail relationships that needs to be burst, how can I go about doing this.
ReplyDeleteRegards