Hi,
I'd like to make updates to our existing database.
Currently:
Multiple users have their front end that they use to add or edit records. Each record has a unique ID that is labelled as: ABC-MMDDYY-XX.
ABC is constant (does not change).
MMDDYY - is the date the record is created
XX - is...