Global variables and multiple files
I am establishing a set of privileges to limit access to records by fmp user. I am using a data separation model so I have two files, one almost exclusively interace the other data. I am storing user identifying information in global variables in my interface file
which are used in the priviledge set to match similar fields for any particular table. I cant seen to get the global variables to be work properly in the data file priviledge evaluation. Works fine for tables that are local to the interface file, but not for those in the data file...
I thought global variables were session scoped. Do global variables span external data references for a purpose such as this? If not can anyone recommend a method to accomplish this?
You might want to try Global fields instead of global variables.
Define a text field for each and use field options to specify Global Storage.