Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 912260 - Last Review: January 26, 2006 - Revision: 1.3
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
On This Page
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:
- 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.
MORE INFORMATION
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.
- In the Database window, open the Orders table in Datasheet view.
Note You experience the problem that is mentioned in the "Symptoms"
section.
APPLIES TO
- Microsoft Office Access 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please