What does a + sign indicate?

M

Milind

I created two tables and had a primary key to one table, contacts. Later when
I opened Contacts table, I saw a + sign before 1st column. Clicking on it
produced a blank row below row1, and it was all blank. What is this supposed
to do, or its significance? Where in Access I can find help on? Thanks
 
T

Tom Wickerath

Hi Milind,

What you are seeing is known as a SubDatasheet. This feature was first
introduced with Access 2000. The blank row that you are seeing represents a
"child" record in the table that is related to your Contacts table. Here is a
link to more information:

About Subdatasheets
http://office.microsoft.com/en-us/access/HP052362161033.aspx

The default for new tables is to have the Subdatasheet property set to
[Auto]. This is not a good setting for a multiuser application:

Slow performance on linked tables in Access 2002,
in Office Access 2003, and in Office 2007

http://support.microsoft.com/kb/275085

Note: You must first turn off NameAutocorrect, at least in Access
2000/2002/2003, in order to get a Subdatasheet setting of [None] to "stick"
(be retained).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top