Thanks for the replies. I now have Calibre setup exactly as I want with additional columns for Price and number of pages. Its a shame Amazon is not more open with its format as there is no way of getting the number of pages in a AZW format book unless its listed on the Amazon web site.
As suggested, I entered the series name in the metadata and I'm happy with the result. The auto incrementing is a nice touch.
Anyway, I have managed to populate the calibre library with contents of my kindle. It then took an afternoon to get the missing metadata and covers. Where this produced a mismatch between the Kindle and the calibre library I deleted the Kindle version and copied over the updated version from the library. I'm so glad I did this now as I only have 96 books! Trying to manage them on the kindle was getting tiresome. Using Calibre is so much easier.