Show or hide the foreign key in a subdatasheet

By default, Microsoft Access doesn't display the foreign key or the matching field in a subdatasheet. However, you can show the foreign key field temporarily.

1. In the datasheet, click the expand indicator (+) and then select a record in the subdatasheet.
2. On the Format menu, click Unhide Columns.
3. Select the check box next to the foreign key field.

Notes

• The next time you open the datasheet containing the subdatasheet, the column or columns will be hidden again.
• Hiding or showing these fields changes only the appearance of the subdatasheet; it does not modify any relationship or source object.