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