Make Global NOT Local?

[MelJ]

I'm Running Server 8 and have a perplexing situation.

I have a notes table. Let's say User A inputs a note. I've included the ability for any other user to append the note.

When User B appends User A's note, my script fills in a field to notify User A that their note has been appended. I've written a script that will check the table at a certain increment (say every 10 minutes) to see if a note the user has written has been appended.

I have all of this working just fine EXCEPT.......

The script I am using has to change to the layout that shows the records of the notes table to check for changes. I have included that if get(recordOpenState) is not equal to 0 not to run. Obviously this is in case the user is in the middle of creating or editing a record, the self running script will not cause a problem. But I cannot get it to return the user to EXACTLY the spot they were just before the script ran.(especially on a tabbed layout)

IF I could somehow update a global field on all users machines I would have the problem solved! Since you can check the contents of a global field from anywhere without changing to a different layout I could check the global and if it meets certain criteria give the user a custom dialog asking if they want to view the appended note.

I hope I've described this well enough and am on bended knee for a solution.

Thanks,

Mel

[normanicus]

I'm not quite sure from your description but here are a couple of ideas:

1. Try a one record table and store your values in there but not as global. Trouble with 'universal' globals is how to block them while someone is using them. Record locking is no good in this case as it will block all values in the record.

2. Maybe a table with one record per user would be more suitable. Stock each users attributes in relation to your notes table there.

How do you propose to dynamically record the position of the cursor in a text field?

Norman