How a main report and subreport are linked

When you insert a subreport that contains information related to data in the main report, the subreport control must be linked to the main report. The link ensures that the records printed in the subreport correspond correctly to the records printed in the main report.

When you create a subreport by using a wizard or by dragging a report or datasheet from the Database window to another report, Microsoft Access automatically synchronizes the main report and subreport if:

• You have defined relationships for the tables you select, or you have defined relationships for the tables underlying the queries you select.
  
  
• The main report is based on a table with a primary key and the subreport is based on a table that contains a field with the same name as that primary key and with the same or a compatible data type. For example, if the primary key of the table underlying the main form is an AutoNumber field and its FieldSize property is set to Long Integer, the corresponding field in the table underlying the subform should be a Number field with its FieldSize property set to Long Integer. If you select a query or queries, the underlying tables in the query or queries must meet the same conditions.

Note   Microsoft Access uses the LinkMasterFields and LinkChildFields properties of the subreport control to link the main report and the subreport. If for some reason Access doesn't link the report and subreport, you can set these properties directly.

How?