What is a relation?

Tables may be related to one another - an invoice table naturally combines information from a customer table and a product table. In this case, the invoice table is called a relation. You can create a relation from selected fields from related tables. The relation then becomes a table in its own right, albeit dependent on the tables from which it is formed.