You would think MS-Access would be smart enough

to recognize its own auto-assigned PKs, and not try to auto-link them when you add tables with them to the query pane.