Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Limited Access and Queries not functioning

mberding
in Security Concepts

Featured Replies

I have a DB that's pretty simple, really. Standard User can see and modify only the records they created. Supervisors should be able to edit a subgroup of users' records, all said subrecords have the Supervisor's login name already in a text field in the record.

The Standard User is doing fine. The Supervisor can view and edit the correct records. BUT - the supervisor can only get to those records by manually browsing and clicking through records to find the correct one. When the supervisor does a "Find" on any field, they get "No Records match this request." Obviously this is a false error message, the records exist.

So why can't my Supervisor's search for records?

The basic code for viewing records at the Supervisor level is:

Get ( AccountName ) = Created_By or Get ( AccountName ) = Supervisor_Name

Help!

Create an account or sign in to comment

https://fmforums.com/topic/32436-limited-access-and-queries-not-functioning/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.