subdatasheets

[Jess]

Hey everyone...for some reason i cant seem to figure out how to link a table
to display my subdatasheet.its really imp...n ive been trying but the links
with the fields.cant get it right....can someone please reply

 

[Van T. Dinh]

SubDatasheet normally shows the Many / Child Records that are related to the
Record in the (main) Datasheet in a One-to-Many Relationship.

To display the SubDatasheet for a Table, open the Table in the DesignView,
open the Properties window for the Table. In this window, you can enter the
name of the Table (or a Query) to be used as the SubDatasheet,
LinkMasterFields (usually the PK in the main Table) and the LinkChildFields
(usually, the ForeignKey in the Child Table).

If you create a relationship between 2 Tables, Access normally selects the
correct Table to be used as a SubDatasheet for you also.