[Full Access] Script doesn't work with External Data Sources... any work-around?
FMP Advanced v10.0
Operating system version
Windows XP, IWP and FMP under Filemaker Advanced Server v10.0
Description of the issue
[Full Access] Script does'nt work under these conditions....
- Using a data separation model with Scripts in main file, and data in External Data Source with .fp7 file
- Privilege Set in External Data Source for certain data elements set-to 'view only' for certain Accounts and certain data elements with 'Limited' access
- Same Privilege Sets being used in the main file
Now... we have a script (in main file) set to 'Run script with full access privilege' -- but when logged in as an Account with limited Privilege Set, the script will not execute 'Set Field' for the target field in the external data source which was set-to 'view only' for the log-in Account with limited Privilege Set.
This script should execute as if it were being run under [Full Access].
Are we doing something wrong? Or is there a work-around for this apparent issue?