Table display changed, How?

M

Min

Hi,
When I open a table, all the rows have a "-", one row become 3 lines. Click
the "-", it changed to "+" and the row changed back to normal. I don't know
how come the table become like this. How can I change it back to normal
view? I guess this may be because I used an append query to append data to
this table.
 
J

John Vinson

Hi,
When I open a table, all the rows have a "-", one row become 3 lines. Click
the "-", it changed to "+" and the row changed back to normal. I don't know
how come the table become like this. How can I change it back to normal
view? I guess this may be because I used an append query to append data to
this table.
Click to expand...

This is called a "Subdatasheet", and it's showing records in a table
that you have specified as being related one-to-many to this table.

Open the Table in design view; view its Properties; and change the
Subdatasheet property from [Auto] to [None] to get rid of it.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top