Can't even think of a proper word for the question

[margaret]

I'm using Access 2007 ... when I open a table that has a relationship with
another table, I know there is a what to show the information linked in the
second table. However, I can't even think of the word to use to do a search.
For instance, I have tblinsurance linked via "id" to tblexhibitor. When I
open tblinsurance, I can have a "plus" sign that I can click and see the
related information. I know I'm sounding funky here, but for some reason I
am completely drawing a blank. Help. Thanks.

 

[George Nicholson]

Subdatasheet?

 

[Richard]

primary key? foreign key?

 

[Ken Sheridan]

Well, you clearly already know how to view the related rows in a
subdatasheet, but that's a pretty crude method. Better would be a subform or
subreport, or a single report based on a query which joins the tables on the
id columns and is grouped on the primary key of tblInsurance.

Ken Sheridan
Stafford, England

 

[margaret]

Yes, it is a crude method but am fixing a program and just will need to see
the info once. So how can I get it display a subdatasheet. I've tried
looking in help and I'm getting nada. I have the table properties set to
"auto" and still the subdatasheet is not displaying. Any suggestions.

 

[Fred]

If they're already linked, just use the query wizard, select both tables, and
all of the fields in each. This is easy and can be done in 30 seconds. This
will show it all.

 

[Clif McIrvin]

Margaret,

When looking at a query or a table in datasheet view you can from the menu
bar choose Insert | Subdatasheet and link tables and or queries together to
get that "plus" sign on the left of the datasheet view.

Before I started monitoring this newsgroup and began to learn better I was
doing all my development directly in tables and queries ... for a "live"
database forms are *much* more stable because you (the developer) are able
to control what, when and how the user sees the data ...

HTH