I have a SQL table that contains one record for control purposes. In this one record, there is a Next Order Number field. I have a subroutine that opens this table, grabs the Next Order Number, then writes records to several different tables using this Next Order Number. I would like to either lock the control table (preferably) or the one record the whole time this subroutine is running to prevent a second user from being able to grab the Next Order Number until the first user is done with it to insure I don't get duplication errors. This would be a much simpler solution that trying to write error trap routines. Any suggestions?