+ columns in tables in the sample biblio.mdb

  • Thread starter Thread starter bbxrider
  • Start date Start date
B

bbxrider

in the sample db, biblio, all the tables have a '+' column that has links
for that record into the other tables
how is that setup?
what advantages to processing does it provide whereby those links are preset
like that and you don't have to create a separate query, etc to establish
that
is that link automagically updated when recs are added in other tables?
how do access those references say in a report?
have worked a lot with access but embarrassed to say never saw that before
 
It is called "Sub-datasheet" and it was only introduced in
A2K so you might not have seen it if you mainly use A97.
It is mainly designed for the One-to-Many relationship
where the Sub-datasheet shows Records related to the
parent (One) Record in the (main) datasheet.

In the Properties window of the (One) Table, there are a
number of Properties related to the Sub-datasheet.

Professional developers only use datasheets / sub-
datasheets for testing so sub-datasheets are hardly ever
used in professionally-developed database applications.
Proper data entry / edit should be done on Forms, NOT
datasheets anyway.

There is advantages in using sub-datasheets as they are
mainly for on-screen display only and they come from the
relationships you assigned in your database. In fact,
there are reports that sub-datasheets actually slow your
Access application down. See Tony Toews' Web site:

<http://www.granite.ab.ca/access/performancefaq.htm>

HTH
Van T. Dinh
MVP (Access)
 
Back
Top