Can you tell me more about the If () function, and what fields are involved? Are you using global fields? (Global fields work independently for each FileMaker Pro client.)
The If() statement is:
If ( Projects::Client_Type = "Individual" ; Contacts_CLIENTS::Full_NAME ; Companies_PRJ_CLIENT::Name )
Projects::Client_Type is a field defined in each record as either "Individual" or "Company"
Contacts_CLIENTS::Full_NAME is a related occurance of Contacts::Full_NAME witch is an autoenter via a calculation field with the following calculation:
Trim ( Title & " " & First & If ( IsEmpty ( Middle ) ; "" ; " " & Middle ) & " " & Last & If ( IsEmpty ( Suffix ) ; "" ; ", " & Suffix ))
and Companies_PRJ_CLIENT::Name is a related occurance of Companies::Name
The relationships do involve a global calculation field called _GBL_CLIENT that is set to equal "Client" - Since it is a caclulated global it should update for each user automatically. Shouldn't it?
Thank you for the additional information.
When a guest opens a hosted file, it immediately takes on the default values of the global fields set by the host. You can then change the global fields to whatever you want. However, if you quit and reopen as a guest, your global values will be gone and you will return to the original values.
When you open the file, the global will be equal to the Client of the host. You may want to change the calculation to a regular field and use a Set Field command instead to force the relationship.