On 2009 Nov 28, at 23:32, John Wenmeekers wrote:
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)
I may not be understanding the full scope of the problem, but it
seems to me that you've already laid out the essence of the solution:
3 component fields, with a calculation field to generate the ID:
ID =
Prefix &
If ( IsEmpty ( Prefix ), "", "-" ) &
SerialNumber &
If ( IsEmpty ( Suffix ), "", "-" ) &
Suffix
