Thanks for your help. Ill explain the my database in more detail. In the
Equipment table the fields are: Equipment ID, Name of Equipment, Size, Description, Colour, Condition and Cost of equipment (this is the cost to hire the equipment)
Loans table- Loan ID, Player ID, Equipment ID, Date...