This help book is a sub-book to the Accessing and linking tables book covers the following information:
A master-detail form or report displays information selected from one or more related tables in a relational database. It groups the detail rows from the detail tables in relation to an associated row from the master table.
In a relational database, a master table can be linked to one or more related (detail) tables by key fields. A detail table may in turn act as a master table, with other key fields linked to other detail tables. Each detail table contains a masterRowset property pointing to its master table. You can implement a master-detail relationship between tables by setting this property in the detail tables.