 |
||||
 |
||||
|
|
| Form with a Subform | |
 |
|
| The sub-form is the borrower's information. It is linked as a "child" table to the "books" parent table. Notice that one book can have multiple in and out activity records. William returned the book on the 10th and Holly has it checked out at present. This is an excellent example of a "one-to-many" relationship. One book can, over time, have many borrowers. That is why Access is called a "relational" database. This kind of relationship is not possible with an Excel spreadsheet or other "flat file" databases. |
