Video Store Database Project - Multiple hires from one customer help?

[Che Humphreys]

I am struggling to get my head around allowing multiple hires in my rental database I am doing for school.

note: all copies of media have individual LibraryID even multiple copies

I have a transaction table and a hire table as follows;

:Transaction:
TransactionID PK
DateHired


DateDue
DateReturned
CustomerID FK
HireID FK

:Hire:
HireID PK
LibraryID FK
TransactionID FK

:Library: and :Customer:
<< this is straight forward>>

[June7]

Have you looked at the Lending Library template database?

[Che Humphreys]

Have you looked at the Lending Library template database?

No where is a good example of that template located?

[June7]

Open up Access. On File tab, type Lending Library in the 'Search Office.com for templates' box. Download file.