This short screencast will explain why and when a 1-to-1 relationship between two tables makes sense. It will also demonstrate how to create a 1-to-1 relationship between two tables using Microsoft Access.
It will show how primary key fields are used to create the relationship as well as how to use the Lookup Wizard to create a list of possible entries for a field.
See all of my YouTubes organized at learncs.w3spaces.com
Thanks, Lisa Friedrichsen