I am trying to create a simple database which allows us to record inspections carried out to our play equipment in our parks. We have 13 parks and over 200 pieces of play equipment, some of these are in more than one park.
The main tables I have are
TblParks (ParkID) (ParkName),
TblEquipment (EquipmentID) (EqupmentName),
TblEquipment_In_Parks (joining previous 2) (EquipInParksID) (Park) (Equipment),
TblInspectionDates (InspectID) (EquipmentID) (InspectionID) (InspectionDate)
TblInspections (InspectionID) (InspectionDateID) (EquipmentInParksID) (Fault) (datecomplete) (comment),etc..
I have been trying to do this for weeks and despite reading loads of stuff I am still totally lost as to what to link to what, although I think I may have the Parks, Equipment and EquipmentInParks right. Can anyone shed any light please?