Refencia integridad de tabla

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?

0 1 78
1 REPLY 1

To make a table undeletable, uncheck this

TeeSee1_0-1664331142287.png

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.

Top Labels in this Space