Primary Keys

T

T Miller

When you create a primary key in a table and you have several other tables
and forms that use the tables, is the primary to be identified on each table
that is created so that they all link together? And should each form and
subform be bound?
 
J

Jeff Boyce

Thomas

A primary key in a table is a way for that table to uniquely identify its
rows.

If you have normalized your data structure, there's only a small likelihood
(in a one-to-one relationship) that two tables' unique row identifiers would
have ANY relationship to each other.

More like is the scenario where one table acts as a "parent", with
(potentially) multiple "child" records in another table. In this scenario,
the primary key of the parent table gets stored AS A FOREIGN KEY in the
child table. This is considered a "one-to-many" relationship.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

Jamie

My fingers overpowered my brain ... the small likelihood referred to a
non-1-to-1 relationship between tables, and allow for the possibility of a
multi-field natural unique row identifier. ... or maybe I was just getting
statistical...<g>

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Help creating a search form in Access XP 0
Adding data to MS Access from csv file 0
VBA word change keys 0
Do I have to set the primary key to include primary key fields? 3
One-to-one relationship 2
referential integrity and tables 4

Top