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

(Stephane Ouellet) #1

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

(Reza Raoofi) #2

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

(Stephane Ouellet) #3

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

(Aleksi Alkio) #4

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

(Stephane Ouellet) #5

@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 Ouellet) #6

@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.