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
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
__________________________________________
> 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