Relationships di dalam Microsoft Access

Mengenal Relationships di dalam Microsoft Access

 Hello, today  I'ma  teach you about relationship. You know that relationships in Microsoft Access is a relationship between a field in one table to a field in another table. Relationship many in the tables that have a relationship in a order.Instead, you keep order and customer data in two related tables and then use the relationship between the two tables to view all orders and customer information either at the same time.Relationship also closely related to the Primary Key and Foreign Key in the access.Further more, microsoft, there are three types of relationships:

1.One to One, which is a record of data in a linked table with just one record data on another table.
2.One to Many, namely a data record in a table is linked to more than one data record in another table.
3. Many to Many, that is more than one data record in a table is linked to more than one data record in another table.