I'm done on a problem! I'm trying to disable...

[Stephane_Ouelle]

I’m done on a problem!

I’m trying to disable the possibility to ADD a record in a child table if the useremail() isn’t the useremail of the creator of the parent.

For the EDIT it’s working. Any clue?

IN(useremail(),SELECT(Report[Useremail], [Report nb]=[_THISROW].[Report nb])

Thanks in advance

[RezaRaoofi]

Can you provide more details? Where have you entered that formula? Which table is child table, and which one is parent table?

[Stephane_Ouelle]

“Report No” is parent, child is “Action” Thanks

[Aleksi_Alkio]

Try it like USEREMAIL()=[Report nb].[Useremail]

[Stephane_Ouelle]

@Aleksi_Alkio Can I get the parent value to see if it’s in READ_ONLY or ADDS_UPDATES mode. It could be easier.

[Stephane_Ouelle]

@Aleksi_Alkio I tried your line, the test in the “expression assistant” are good, but the button “New” doesn’t appear. The table allows ADDS and UPDATES.