Delete condition

[salehej]

Hello guys

I have 2 table

Table 1 for employees
Table 2 for jobs
i want when I delete row from table 1 the condition check if the employee have job in table 2 if have stop the action if not continue to delete the row

Thanks guys

[Marc_Dillon]

salehej:

i want when I delete row from table 1 the condition check if the employee have job in table 2 if have stop the action if not continue to delete the row

You only want a user to be able to delete a record only if they do not have a record in some other Table?

ISBLANK( FILTER(
  jobs
  [employee] = [_THISROW].[employee]
) )

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

FILTER()

Select rows of table or slice

[salehej]

Thank you so much