Yearly Reset of Auto Entered Serial

[lonntj]

So I have a table that tracks transactions, and each transaction gets an ID number. The ID Number looks like YR-### and is a concatenatation of the YR field (calculation of two digit year), and the auto-entered serial. How to I reset the serial number every year or every time the YR field changes? This one's been killing me.

Thanks,

Lonn

[-Queue-]

See attached.

Note that the relationship is sorted by Incrementor descending, so that the first related record has the largest Incrementor, and that Incrementor's auto-enter calculation has 'do not evaluate if all referenced fields are empty' deselected.

When the year on your computer's clock changes, so will the Year field and, consequently, the next created PseudoSerial.

I call it a pseudoserial because you should still use the real serial for relationships, etc. PseudoSerial should only be used for visual purposes.

PseudoSerial.zip

[lonntj]

Slick. Thanks!

[casrch]

its what I need, but It doesn

[-Queue-]

It will, if you make one simple change. See here.