Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2004

Tip: Looking for answers? Try searching our database.

Links

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Billking44 - 20 Dec 2004 22:45 GMT
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.
John Vinson - 21 Dec 2004 02:32 GMT
>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]
billking44 - 21 Dec 2004 02:53 GMT
Many, many thanks.  I think I understand my confusion now.  again, thank you
for taking the time to help out a "green horn".  Happy Holidays Guys, and
again, Thanks.

Bill King

> >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
[quoted text clipped - 21 lines]
>
>                   John W. Vinson[MVP]
Duane Hookom - 21 Dec 2004 02:32 GMT
Adding records in one table should not generally add records into another
table. For instance, if you add an Order record in the Order table in
Northwind, it doesn't automatically add a record to the OrderDetails table.

Signature

Duane Hookom
MS Access MVP

>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
[quoted text clipped - 4 lines]
> in
> one table populates the other tables.  Please help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.