Fyi: The Accession # field is an alphanumeric field [to append A/B/G/Z/L/E prefix]], but only numbers can be entered, and it auto-increments the same series for all collections/areas
Copying the irn is an option, but using Exhibit number/something informative might be better [if do-able]
Don’t use Accession # field, use Other Institution # field which has no logic and is text type field. Relabel as Acq. No. only for Acquisition Tab.
The event attachment had been added to the AllAcc2Tab to allow proper connection the exhibition and there EX# does not need to be duplicated in as the Acquisition #. Will relabel and use the AccAccessionNo field as it currently stands with the E prefix.
DISCUSSION POINTS: