Is this what you are referring too for compound index? ....will look for answer tomorrow if you're posting... If not...Have a great weekend.InspectionID_FK and ItemID_FK as compound index to prevent duplicate pairs
Set those two fields as Index: Yes, (No Duplicates)?
Removed Primary Key on tblInspectionDetails - should it remain an autonumber field or just a number field?