With this section, you will come to understand the term relationship, and be able to outline the different types of relationships and when they should be applied. We will look at the rules for creating relationships between tables in a database.
Access is a relational database, which means that tables that are related will have fields that have a common association between them. Related fields do not have to have the same names, but it is obviously easier to identify the relationship if they are the same. Related fields are required to have exactly the same data type unless the primary key field is set to AutoNumber. This will only work if the field size property is the same on both matching fields, for example, Long Integer.
A relationship is a join (or link) between related fields in the database.
If we think of a company when creating a database, we would...