Welcome to the forum...
While waiting to see if you are going to post your dB, I played around with your description of what you think the tables should be. This is where I would start:
Code:
tblEquipment
-----------------
EquipmentID_PK Autonumber (PrimaryKey)
EquipTypeID_FK Long Integer (Link to tblEquipTypes)
Equip_MFGR Text (<<-- could be a FK field to tblMFGR)
Equip_Serial_Num Text
tblEquipTypes
-----------------
EquipTypeID_PK Autonumber (PrimaryKey)
EquipTypeDesc Text
tblSites
-----------------
SiteID_PK Autonumber (PrimaryKey)
SiteName Text
SiteLocation Text
tblEvents
-----------------
EventID_PK Autonumber (PrimaryKey)
EquipmentID_FK Long Integer (Link to tblEquipment)
MoveFrom_SiteID_FK Long Integer (Link to tblSites)
MoveTo_SiteID_FK Long Integer (Link to tblSites)
EventDate Date/time