what is the difference between join and relate?
While join appends attributes to the end of a table, relate creates a temporary table for all the matching records. All tables link with each other based on cardinality (1-1, 1-M and M-N). Both join and relate work on the principal of having matching unique IDs in two tables.