Using prefixes on fields and variables immediately identifies what data type the field/variable is.
PK == primary key
FK == foreign key
int == integer
txt == text
Using this notation (see
http://www.exceluser.com/explore/vbastds.htm, http://en.wikipedia.org/wiki/Hungarian_notation and
http://en.wikipedia.org/wiki/Hungarian_notation), Long after a program is written, it is easier to read and understand.
You left the foreign key control out of table tblComp causing tblEquip and tblComp to not be related. Build that relationship in the Relationship window, after first adding field FKEquip (having a numeric data type) to table tblComp. Then your tables will tumble correctly.
Did you read what cascading updates/deletes are about? I gave you a link.