I am sure some of you have heard of the trick for sorting portal columns by creating a calc field in the related file where the portal relationship is set to sort on the calc field. The calc field uses Case to test the value of a global field, depending on the value of the global the calc is then evaluated to different fields in the related file. The global is set from a script in the main file. My question is how is this going to work in a Multi-user setting. Given that the calc resides on the machine running FM Server and each logged on user gets their own global. Does anyone have any experience as to how this will work and are there any problems that may be encounted.

Thanks

Don't get too hung up on the fact that the files reside on a machine with FM Server. This is really transparent. The important fact is that each user has a unique set of globals. A calculation field based upon a global has a value which is unique to each user making the sort order unique to each user.

-bd

Thanks bd.

If no one has told you how much you are appreciated here, then let me be the one. You are appreciated.

graham