Gotta brain freeze tonight...

THE QUESTION: If I use globals in a calculation, and the file is a multi-user, will all the users have different calculations based on their global?

Why you wonder.... I'm working on a scheduling program and use a global date field as a reference to display particular sets of dates.

I want the user to be able to change the global date be able to see various other dates.

The schedule file is a list of times with calc fields that display data hoizontally in seven fields (one for each day of the week). The fields are based on calcs that incorporate the global field.

Thouroughly confused now?

When all guests open a multi-user file, the global field will initially have the same value for all users. Once open, each user's global field is independent of the rest -- they can all be changed to different values. I believe the global field will be set to the value of the guest that logs off last.

It sounds like that's what you want.

You could include a startup script to set the global field the same for each user.

That way, not dependant on what the last user who logged off had set.

I think the golobal field will be fine, I guess my concern was the calc field that uses the global field as part of the calculation.

This brings me to question - even though the calc field is not a global field, the fact that it uses Global fields, will it behave like a global filed and each user have different calc fields based on thier global?

[ February 18, 2002, 08:23 AM: Message edited by: BruceJ ]

This is starting to sound like my db.

we use this feature to enable users to view their activities, via a line portal by type of activity and who the activity is for.

Two (sometimes more) global fields, worked together in a calc to change how the portal is displayed.

Multi User (50 users).

Also used with the activities and an appointments db. This uses a global user and date field to display not only the diary, by day, week, month or group (which required a lot more globals) but also to display a portal list at the bottom of the screen to display all other activities for that particular time period.

A lot of globals and a serious amount of relationships are happening on just a couple of screens. You want to see Analyzer 3.0 (www.wmotion.com) cope with that (and then get visualizer to give you an ERD and try and track a relationship through it).

but I digress, to your question.

In our solution the calc fields react to the global fields, making it different to each user.