This video from YouTube shows the basic way to set and join two tables together in the relationship window viewer tool.
This gives you a clear and simple step by step instructions on how to join two tables creating a global/permanent relationship. Access database then recongnises this setting and releases more functionality including the ability to expand and collapse related records in a table.
Tags: Access database 2007 , Access Relational Databases , How to set Access 2007 relationships , indexing , joining tables , primary key , RDBMS