I have created a database with 5 tables and three forms. My relationships
are made as well as my primary keys. When I enter data though, the data does
not populate the pther tables. I try to use the Linked Table manager and it
returns that no tables are linked. How do I make it so the data I enter in
one table populates the other tables. Please help.
You misunderstand the purpose of relationships. Having a relationship
defined between tables does not automagically add new records to the
"child" tables; instead, it PREVENTS you from adding a record which
would be an "orphan". There is no need and no benefit to creating
empty "placeholder" records in the child tables. Typically you would
use a Form based on the "one" side table, and one or more Subforms
based on the "many" table(s); when you enter a record on the subform
it will automatically fill in the Master Link Field into the subform's
Child Link Field, creating the link when you add data (but not
before).
The Linked Table Manager is a totally separate issue; it's not for
maintaining relationships, it's used when you have the Tables in one
database and the Forms, Queries, and so on in a different database.
This technique is very commonly used for multiuser databases; everyone
gets a copy of the "frontend", all linked to the shared "backend". But
again, this has no direct bearing on the relationships!
John W. Vinson[MVP]
