Actually that's what I have right now, but the thing is there could be a concurrency issue in that setup, because it is a two process 1.) Update the seed table, 2.) Insert a new record on the main table using the generated ID. Anything could happen between the two process.
I will not be restricting it to three digits, it's just that the minimum is 3 digits,