Replied in the microsoft.public.access NG, your posting with the same
question on Nov. 19. The answer was:
I understand you are confusing "databases" with tables? A database is made
up of multiple tables and, in Access, it mostly contains additional objects
too, like queries, forms, reports etc (in Access all of this is stored into
a single file, mostly referred to as the database).
Having cleared this, what you are describing is table joins. To get this
kind of behaviour, you must define relationships between tables in your
database (Tools > Relationships), Enforce Referential Integrity and Cascade
Update Related Fields.
HTH,
Nikos
