TechTalk: Performance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

Create a Relationship There is a benefit to creating an explicit relationship, especially when the Primary Key does not match.   In the sample database, the Primary key for tblMovieTitles is simply ID.   The unique integer that identifies each Movie is the Foreign key, not the Primary Key, for tblMovieRented. It is named MovieID in tblMovieRented.   3. Create a Join between tables Select MovieID from tblMovieRented Drag MovieID onto ID in tblMovieTitles. Relationship Tools->Design