2 Replies Latest reply on Oct 25, 2016 2:27 PM by coherentkris

    Checklist for multiple users to enter data cleanly


      Hi FM community,


      I want to insure won't interfere with multiple users entering data at the same time.


      The set-up is: Filemaker Server hosting an Order Processing App with multiple users entering orders into the system,each user using Filemaker Pro in their own PC.


      The question is, would any of the following be a potential cause of data mix-up(one user can potentially cause other users to see changed data,) or would they be compartmentalized(i.e. each user sees his/her own values)

      Global variables or local variables used in scripts.

      Global fields.

      Virtual Lists generated off of ExecSQL.  If we manipulate this, only one user can use it(like record-locking)?


      I designed the system using one-user scenario and as we test it in server environment, I want to make sure it works.


      Any help would be greatly appreciated.


      Thanks in advance!