Upon a new record button click I want to auto create the next ID number that is formatted as
MN-xx-xxx (MN-2 digit Calendar Year-3 digit incremented number)
I have a format of "MN-11-"999;0;_;;_ to give me the correct format, but I need now to have it autoselect the year and the the next number.
Next criteria is at the end of the year (say the last id was MN-11-578, at the next year I need it to start at MN-12-001.
This field is the primary key, but is not an autonumber field.
Table name is "LIR_Master" and field is "LIR_LIR_#"