Using Subdatasheets


graphics/08inf13.jpg

graphics/one_icon.jpg

After you've opened the first database table, click the plus sign next to the record whose subdatasheet you want to view.

graphics/two_icon.jpg

The data from the related table is displayed. To hide the subdatasheet, click the minus sign next to the record.

graphics/three_icon.jpg

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.

***end tip***



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net