(FMP Advanced 16, FM Server 16)
I am getting the error "Relationship Not Found: This operation could not be completed because the target is not part of a related table." when I log on with a restricted account.
I cannot figure out how to debug this properly.
On login I have a script that checks the privilege set and in the case of the restricted user does
1. Install a restricted custom menu set
2. Disallows the formatting bar
3. Checks if I am in WebDirect (SystemPlatform = 4) and if so, hides and locks the toolbar
4. Goes to the layout "PortalTest", based on table "Company".
When loading this layout, I have another script that runs show all records and then calls a script that filters the found set as follows, and afterwards goes to the first record:
1. enter find mode (no pause)
2. sets to timestamp fields
3. sets a calculated field
4. constrains the found set
5. sorts the records
The layout shows the company name (field in table "Company"); the country via a relation between tables "Company" and "country"; and a portal to show records from the table "activities", which is related to "Company".
The calculated field starts a recursive custom function, and there are a couple of ExecuteSQL in it, but as far as I understand these should not result in a "relationship not found" error.
Also, when I switch to another table and then back to "PortalTest" I do not get the error (Not sure if this is due to the fact that FileMaker only throws it the first time?)
On the first load, however, I see that the scripts are not correctly executed, since the constraint is not happening: I see all records from Company, including the ones I tried to hide.
Subsequent loads do perform the scripts correctly, though; i.e. after switching away from "PortalTest" and back, I only see the records I intended to show.
What's weird is that the error started to appear after I changed buttons in the navigation area; apparently unrelated to any database or permission configuration that might be at play here...
Any help is appreciated.