Troubles on design of database

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

I am designing a database and I want the primary key of the main table to be
the primary key of the other table to allow for tracking information between
the tables. Can this be done and if how? I appreciate any information in
the answer of my problem. Thank you in advance
 
I am designing a database and I want the primary key of the main table to be
the primary key of the other table to allow for tracking information between
the tables. Can this be done and if how? I appreciate any information in
the answer of my problem. Thank you in advance
Click to expand...

Two tables with the same Primary Key will necessarily have a
one-to-one relationship, which is rather uncommon. Just what do you
mean by "tracking information between"?

To keep two tables linked, the simplest solution is to use a Form for
the "parent" table and a Subform for the "child", using the subform
control's master/child link field to ensure that child records stay
synched with the parent.
 
Back
Top