First, I am a beginner at Access, done it for awhile but always trying to learn more.
I have created a database in Access 2013 that tracks different parts of a project for the construction of towers. The main table is "tblSites" with many related tables, the primary key for most tables is "Site Number". I have created many working relationships to some of the tables and they are working fine. I recently wanted to add a table called "tblNTP" and have a relationship with "tblSites" with the primary key for both being the field "Site Number". I have been unable to determine why the relationship is not working and I have a sore forehead, hoping that a different set of eyes sees something that I am missing. I have attached screen shots that I hope will explain any questions you might have.
Thank you for any assistance in advance!!