I am creating a tracking database in which I need a Custom ID table field which auto assigns a unique number to each record, to be formatted like this 2500-2021-0001, where 2500 is a fixed/constant, 2021 is the year the record was created and 0001 is the sequential record number.
Thank you
khaugen