Restricting Row/record level edits as per ownership

Hi , I am trying a app

I have chef table with key and email id . refering to receipes columns with key

Chef need to login with email ,

I want chef to be able to view all other cheff

I want chef only able to update his own recipes or add new .

chef cannot update add remove others recipes

I know how to restrcit view but not sure about edits

1 Like

Thanks it works ,

now how do i restrict if email id is another table , specifically i want to write select like below

USEREMAIL() = Select email from CookTable where Cooktable.key = Recipe.Cookrefkey

I need correct syntax … I tried like

SELECT (Cook[email] , ([_THISROW].[Cook] = Cook[key] , YES) this results into an error

1 Like

This?

(USEREMAIL() = [Cook].[Email])

See also:

1 Like

Is that simple? Email is in cook table which refer to recipe and I want to put edit restriction on recipe .still I will trt

1 Like

Worked thanks for help

2 Likes