Recent content by Jane-e

These are great responses, and I think it fills it the missing gap. Thank you to Galaxiom, Bob, Sean, and Paul. Bob — the link to the tutorial was perfect! Is the definition of "surrogate key" an autonumbered field, or any primary key? It also sounds as if the decision when designing the...

A book I am reading says, "Composite keys are typically used if a table has no single field (with a set of unique values) that can serve as the primary key." I have used Access for a while, but have never quite grasped what kind of situation needs two primary keys. Can anyone shed light on this...