Administrator: Receipts 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

For the Record The query automatically created a relationship between tblMovieRented and tblCustomer. This join looks like a line from one table to another.   You will see a join from CustomerID in tblMovieRented to CustomerID in tblCustomer. The RentalID joins the MovieTitles table to the MovieRented table.   What is the relationship between the MovieRented table and the MovieTitles table? The MovieRented table has a MovieID field. The MovieTitles table has ID as the Primary Key.   Try it: Join the Tables Drag MovieID to ID. You have joined these tables together. Create->Query Design