This is the requirement (theory is all well and good, but if it doesn't give the client what they want, it doesn't pay the bills). They won't be generating...

Thinking about it, I probably need a stored procedure that generates that number so that I can assign it before I create the records (though the core code to do...