'Til now I'd discarded the country code identifier from results, thinking it was superfluous. It didn't even twig when I was entering records into my database for the first time when two horses of the same name, competed on the SAME DAY (one in Australia, one in NZ; naturally). Name and date comprised my record key, I added the track to ensure uniqueness and went happily on my way.

Now that I want to use my database for different means, it's a whole 'nother story. If only I knew everything I wanted to do before I knew I wanted to do it...