Como evito que se elimine un registro Ej tabla Cliente ,
CodCliente:001
Nombre: Jourdan
si es esta referencia otra tabla Ej Tabla: Servicio:
CodServicio:2000
CodCliente:001
Si la tabla de servicio ya contiene asociado el cliente que no se pueda borrar el registro en la tabla cliente ya que esta referenciada?
To make a table undeletable, uncheck this
If you want specific rows to be undeletable, set a necessary condition in the Behavior of its Delete action/behavior.
I suppose you want to check if a particular customer is used in the Service table. Then you can use the following expression
ISBLANK([Related Services])
I am assuming your customer table has an automatically created column that shows the related services records.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |