A new requirement from our government gives me problems. Documents need an ID formatted as
prefix - serialnumber - suffix The prefix - serialnumber combination is no problem, solved with a relationship and the Max() function +1. Unresolved is the suffix that needs to go from A to Z and is not for all the documents. From the 256 documents, only 17 need a suffix. Any hint how to accomplish it without the construction of a gasfactory (like I have now) TIA
