I've found the cause of the problem.
All of our data files had the file extension '.mdf' (don't blame me, I didn't create the database) Presumably SSMS looks at the extension, assumes (not unreasonably) that there should only be one mdf file and so uses the name of the first mdf file it comes across.