Sub-Tables

D

Donna

I am trying to write my first data base in Access. Is it best to have table
with relationships or sub tables that also have relationships? What I am
trying to do is trace a project that is several different apartment in a
building and the work that needs done in each one apartment and each room of
the apartment. Any help would be GREAT!
 
J

John Vinson

I am trying to write my first data base in Access. Is it best to have table
with relationships or sub tables that also have relationships? What I am
trying to do is trace a project that is several different apartment in a
building and the work that needs done in each one apartment and each room of
the apartment. Any help would be GREAT!
Click to expand...

A "Subtable" is just a new way that Microsoft has provided to let you
establish a relationship. It's slow, it's buggy, and it's unnecessary:
table datasheet view is inherently very limited, and you're much
better off creating two Tables, using the Relationships window to
establish one-to-many relationships (Buildings 1:n with Apartments,
Apartments 1:n with Rooms), and use Forms to interact with the data.
Viewing table datasheets should be reserved for design and debugging,
not routine use of the database.

John W. Vinson[MVP]
 
D

Donna

John,

Thank you for your help. The book I was reading was not help in this matter.
Youe Did! Thank you!
--
Thanks

Donna
 
Top