Join the Tables
join Tables you create a relationship between one table and
another. The join is created by matching Fields with the same Data
Type: Text with Text, or Numbers with Numbers.
example, we will join tblMovies to the Genre and the Rating.
Try it: Join the Tables
Field from tblMovies: Rating.
Field to the Rating Field in tblRating.
You See? The Join is represented by a black line from Rating in
tblMovies to Rating in tblRating.
Too: Join the Tables
Field from tblMovies: Genre.
Field to the Genre Field in tblGenre.
You See, Now? There should be another Join
from Genre in tblMovies to Genre in tblGenre.