Hey

This might seem like a dumb question, but I am in the beginning phases of designing a filing system for a court office. I am wondering if setting a global field in a database will cause problems if the solution is implemented using advanced server 7.

For example, Im using a script to add parties to a lawsuit record using a join table. I'm using a global field in the parties table to keep track of what suit the user is adding parties to. Now, if there are more than one users adding parties to different suits, I'm guessing one user will overwrite the global field entry so that the first user ends up adding parties to the wrong suit record.

Is there a way to get around such a problem? What kinds of things do I need to keep in mind since I am designing a system that is going to be used by multiple people at once?

Global fields are local to each user. No user can overwrite another's globals. But keep in mind that global data will not be saved when a user closes a file in a multi-user solution hosted by Server.

awesome, thanks a lot.