I have a setup like this
# Category table:
id
category_name
visible_to_executives (can be Yes or No)
# Transaction records table:
id
category (lookup field to categories.id )
more data fields
1) Only users that are "executives" should be able to select categories where category.visible_to_executives = 1
1b) Ideally they should not know that such categories exist at all in my application.
2) Only users that are "executives" should be able to see *transactions* that are linked to a category where category.visible_to_executives = 1
Is it possbible to set up this scenario?
Thanks a lot for all help.
Restrict access to certain records
Re: Restrict access to certain records
Hi,
please check me footer for Column-Value-Based-Permissions. This might help you.
Olaf
please check me footer for Column-Value-Based-Permissions. This might help you.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Restrict access to certain records
Thanks a lot, Olaf. That seems like exactly what I was looking for