This short screencast will explain how to display the expand and collapse buttons in Table Datasheet View that allow you to display a subdatasheet. A subdatasheet shows the records in a related table.
It will show how the table properties of Subdatasheet Name, Link Child Fields, and Link Master Fields control subdatasheets. It will discuss one-to-many relationships and explain how the parent and child tables are related with a common field which is called the primary key field in the "one" table and the foreign key field in the "many" table.
See all of my KZfaqs organized at learncs.w3spaces.com
Thanks, Lisa Friedrichsen