I have one database that holds the tables called InvoiceDB. I created 3 databases with forms, queries and reports only for emplyees to pull up records that are related to their customers and is linked to InvoiceDB where the forms, queries and reports. On the forms there are 3 fields that allow multiple values but if two users are on the form it locks one user with an error of "could not update currently locked by another user". On the form Record locks is set to EditedRecord. I am using Access 2010 and Windows XP.