Anti-Delete Code

Noelit

](*,) ](*,) ](*,) ](*,) ](*,) How do i add code to prevent a user from deleting data in a list i.e to prevent someone 4rom deleting a Hotel Floor before all the rooms are determined to be empty.

kine

Add the check into OnDelete trigger of your table...

arindom

Write code ONDELET of the table to validate .

DenSter

Set the 'DeleteAllowed' property to No, make the form not editable, develop functionality to only allow certain people access.

Wait.... what about setting up the proper permissions? That way you don't have to program anything.

apertierra

DenSter wrote:

Wait.... what about setting up the proper permissions? That way you don't have to program anything.

Noelit wrote:

data in a list i.e to prevent someone 4rom deleting a Hotel Floor before all the rooms are determined to be empty.

Sure... permissions... and I suppose that they will change permissionsn after manually checking if all the rooms are empty.....
Noelit: You will need modifying the ondelete trigger and, in there, do the calculations required to check if they are allowed to delete the record, and, if not, give an error.