Thanks for the reply Bonnie. That is actually the best solution for a majority of my tables, but it doesn't work for a select few. Sometimes I need to know the key value before a record is inserted into a table. The key value may be dispersed to a few other tables. Any ideas on the record locking?