We have a header table that has a field validation default value for it which uses RECCOUNT() to autogenerate a unique number (lets call the field RFQ). As long as the table is not packed, we are fine. However, the code to create a new record and then populate it and child records is not working well in a multiuser environment. If I have nothing in my code to SET REPROCESS or do anything with LOCK or MULTILOCK and I do an APPEND BLANK on this header table and then immediately copy the "RFQ" field value. Can I be sure that no matter what, the copy of that RFQ value will never conflict with someone else running the code? In other words, when you do an APPEND BLANK how can you make a lock on that record...or is there a better way to do what I'm asking?