In a Microsoft Office Access 2003 database, when you try to
click the plus sign
(+) to drill down into the related records of a child
table, the plus sign
(+) may not appear. You experience this problem when the following
conditions are true:
- You use Office Access 2003 to link to tables that are in another database.
- The tables are in a parent-child
You do not experience this problem in Microsoft Access 2002 or in Microsoft Access 2000.
To work around this problem, follow these steps:
- Establish a one-to-many relationship between the parent and child tables. To do this, click Relationships on the Tools menu in Office Access 2003.
- Create one form for the parent table.
- Create another form for the child table.
- Set the Default View property of both forms to Datasheet.
- Add the child form to the parent form.
Note This workaround provides an interface to enter data as in
earlier versions of Office Access.
Article ID: 912260 - Last Review: January 26, 2006 - Revision: 1.3
- Microsoft Office Access 2003