Troubles on design of database

[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

 

[John Vinson]

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

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.