After you've opened the first database table, click the plus sign next to the record whose subdatasheet you want to view.
The data from the related table is displayed. To hide the subdatasheet, click the minus sign next to the record.
The subdatasheet is hidden.
INTRODUCTION
You might want to view (and possibly change) data in a table that is related to another table. To do this, you display the first table's subdatasheet . The subdatasheet displays the record information from that related table. You can then collapse (hide) or expand (show) the related record in the other table.
TIP
Editing the Subdatasheet
You can edit data in the subdatasheet. If you have set up the relationship to enforce referential integrity, the changes will be made and saved in the original, related table.