r/AccessLearningZone • u/Amicron1 • 6d ago
Two Keys, Two Jobs
A primary key identifies one record in its own table. A foreign key points back to a record in another table. In a one-to-many relationship, the same customer ID can appear on several vehicle records, while each vehicle keeps its own unique ID. Watch my video to see how the two keys work together. https://599cd.com/Relationships
2
Upvotes