Currently I have a shared macro that has forms. This macro has add, edit, delete functionality. My problem is that i want multiple users to use it. For example 2 users (1 adding a new record, 1 user updating) or (2 users adding a record at the same time). I have a function that generates id automatically (ex. employeeid), the problem is if two concurrent users add a record the other record will be overwritten. Please help

thanks