i have an issue that i would like to resolve as soon as possible. for a single user, the solution i have works great. however, with the file being hosted on FMS (FMS 15) with a multi-user setting, data entry is not working out too well at all. with the multi-users, i'm getting a record locking error message. here's my setup:
i believe this is a "magic key" setup, correct? if not, then i'm definitely wrong in how i have set this up...lol. the record locking seems to appear when anyone of the users make an entry in the Serial Number field.
please advise and assist how i can improve this solution, and future ones.