Flannery, this is a long answer to your long question so bear with me! I believe the problem your experiencing boils down to this: archival numbering systems are completely different from object numbering systems. I have both artifacts and archive here and this is the difference:
For artifacts we assign an accession number to the gift (2017.001) and then each object is affixed with a modifier of this number (2017.001.00001). The number here tells me this is the first object donated by the first gift in 2017.
For archives we assign an accession number to the gift only (A2017.001) and the catalog number is different, it is made up of four parts: Collection, series, file unit, item. This is how it looks in practice. I have a collection of Photographs (PHO). Within that collection I have several Series which I number (01, 02, 03). Each series is a different type of photograph. Within each Series, I have several File Units or groups (001, 002, 003). Within each File Unit, there are individual pieces or photographs (0001, 0002, 0003). A complete catalog record and the number affixed to a photograph looks like this: PHO.01.001.0001. Yes, it's more complex than the accession number but this allows me to add photographs from different donors to the same collection.
Example: Joe Shmoe donates a photograph of his grandfather in military uniform. I create a Photograph collection (PHO). The first Series is for "military". I place the photo in a File Unit for "uniforms" and assign this as the first photo: PHO.01.001.0001
Then Jane Doe donates a photograph of her daughter in military uniform. I can add this to the first, its PHO.01.001.0002. All the military uniform photos are together making it easier to research and find later.
Now Sam donates a photograph of a building on a military base. It's not a uniform, but it is still in the Series for military, so I create a new File Unit for "bases." This photograph then becomes: PHO.01.002.0001. It's the first photograph of the File Unit for bases within the military Series of the photograph Collection. Phew!
There are numerous books and seminars out there to learn archival numbering systems. It will feel like you have two completely different systems working in your museum and that's because you will. But in the end, archival material is much easier to retrieve when it is cataloged properly and that means leaving the accession number out of the numbering system.
------------------------------
Jenny Benjamin
Director
Museum of Vision
San Francisco CA
------------------------------