Tables With?

[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!

 

[Golfinray]

Those are lookup columns. Look up help on lookups.

 

[JulieS]

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!

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

 

[Albert D. Kallal]

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!

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