Do any of you know why Access (2010 here) is making duplicate tables then renaming them _1 in the relationship chart? These tables don't show in the table list. Thank you.
You're probably using that "extra" table somewhere else in your database. You have dropped the table TWICE onto the Relationships window and joined it to some other table or to itself (like WayneRyan mentioned).