I'm making it sound bad! LOL!



The link is the auto number from Contacts table - to a number field I added called ContactID in History table, then joined. History table actually has it's own auto-ID.

A bit self-taught with Access - so I've always joined tables by adding a number field to a child table - and linking it back to a 'parent' auto/index field.