Originally Posted by
orange
Putting the values into the database table is one thing, but giving the physical key to the specific individual is another.
Seems these have to be "in sync".
Just a thought, but KeyNo seems to be a separate concept than KeyX is assigned to PersonQ.
Does assigning KeyNos in Surname sequence make sense--when Employee leaves or is replaced?
Not saying it's a terrible idea, it might be simple for initial distribution of keys. It's when staff changeovers occur that the alphabetic surname to sequence numbers are no longer equivalent. You may have considered that.
How will keys be distributed physically to personnel?