Tables With?

S

sturner333

I have inherited a database and ran across something I have not seen. I am
sure it is a relationship with another table or query. Next to some of the
columns are '+' signs that expand to records. Can someone give me brief
explanation of these and how they are implemented and can they be removed if
necessary?
Thanks!
 
J

JulieS

sturner333 said:
I have inherited a database and ran across something I have not seen. I
am
sure it is a relationship with another table or query. Next to some of
the
columns are '+' signs that expand to records. Can someone give me
brief
explanation of these and how they are implemented and can they be
removed if
necessary?
Thanks!
Click to expand...

sturner333,

If the '+' are occurring next to each row in datasheet view of the
table, they represent subdatasheets. You are correct, they do represent
records that coming from a table joined to the table you are viewing.
You can remove the subdatasheet through Format | Subdatasheet | Remove.

See help on subdatasheets.

Julie
 
A

Albert D. Kallal

sturner333 said:
I have inherited a database and ran across something I have not seen. I am
sure it is a relationship with another table or query. Next to some of the
columns are '+' signs that expand to records. Can someone give me brief
explanation of these and how they are implemented and can they be removed
if
necessary?
Thanks!
Click to expand...

They are what we call sub-datasheets. (they are NOT lookups as the other
poster suggested).

from the access side, ( not code editor), go help, and type in

subdatasheet
 
Top