Plus sign in table records

[Guest]

I am curious about how a record in an Access table gets a plus sign in front
of each record and is linked to relaional data in other tables when the
record is expanded within the table. Does this happen when relationships are
setup or is it driven by a query of some type?
I have noticed this in some tables and not others and have been wondering
how to establish this feature if I need to. I realize, of course, that the
proper way of veiwing records is with forms, queries and reports but this has
just been a question I've had for a while and didn't know who to ask.
Thanks,
Al

 

[Wayne Morgan]

This is done by the relationships between the tables that you've set up. If
you open the tables properties with the table in design view, you'll see a
property call "Subdatasheet Name". This is the table that the data is pulled
from when you click the plus sign. You will get better performance if you
set this to None. However, to get it to stay at None, you have to turn off
"name auto correct" at Tools|Options|General tab, and uncheck "Track name
AutoCorrect info". If you don't, Access "helps" you by filling this property
back in for you.

 

[Guest]

Al,

The plus signs you see in relationship tables are brought about through the
relationships you create. You get some control options over these by simply
clicking "Format/Subdatasheet" within your DataSheet view of your table. If
you want more control, go to the design view of your table, then view the
table properties (right click/properties). You'll now see more options on
controling these.

You were right, however, in assuming that the best way to handle these is
probably going to be through a form with a subform.

HTH

Aaron G
Philadelphia, PA