Microsoft KB Archive/912260

= The plus sign (+) may not appear when you try to click the plus sign (+) to drill down into the related records of a child table in Office Access 2003 =

Article ID: 912260

Article Last Modified on 1/26/2006

-

APPLIES TO


 * Microsoft Office Access 2003

-





SYMPTOMS
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 relationship.

Note You do not experience this problem in Microsoft Access 2002 or in Microsoft Access 2000.



WORKAROUND
To work around this problem, follow these steps:
 * 1) 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.
 * 2) Create one form for the parent table.
 * 3) Create another form for the child table.
 * 4) Set the Default View property of both forms to Datasheet.
 * 5) Add the child form to the parent form.

Note This workaround provides an interface to enter data as in earlier versions of Office Access.



Steps to reproduce the problem
 In Office Access 2003, create link tables to the Orders and Order Details tables in the Microsoft SQL Server 2000 Northwind database. To do this, follow these steps:  On the File menu, point to Get External Data, and then click Link Tables. In the Files of type list, click ODBC Database. Select the data source to the SQL Server 2000 Northwind database, and then add the Orders and Order Details tables. On the Tools menu, click Relationships. Build a relationship on the OrderID field between the Orders table and the OrderDetails table.</li></ol> </li> In the Database window, open the Orders table in Datasheet view.

Note You experience the problem that is mentioned in the &quot;Symptoms&quot; section.</li></ol>

Keywords: kbtshoot kbprb KB912260

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.