We have a database for our recieving department. For each package recieved, a
lot number is assigned and typed in. Now we are looking to automate the lot
number, having an automatic lot number generated and added when a package is
recieved. I can generate the automatic number, but is there any way to do
this and use the existing field? I don't want to disturbe the previous data
for tracking purposes. If I can't figure this out, I will need to add a new
field and searches become more complicated. Any suggestions?