Video #105
In this video I:
Use a Spatial Join to add a column from a polygon layer (postcodes) to a point layer (pubs)
I then use Add Relate to show the difference between JOIN and RELATE
Finally, I create a Relationship Class, stored in the file geodatabase.

Key points to remember are:
1. A JOIN uses a common field to associate records from one table to another. Its more aimed at a 1-to-1 relationship. A Spatial Join always creates an output feature class
2. Relates define the actual relationship between 2 tables. No data is appended and you select a record to access the related data. Its basically a sort of 'live link'. Good way to represent a 1-to-Many relationship.