Deleting Reference Data
Deleting Reference Data
I have field named 'City' in the table 'City'. In the table 'Address', I have a field called 'City' which is referenced and made mandatory to the field 'City' in table 'City'.
In the City table, I have a record 'Tirupur'. I have created address with reference city as 'Tirupur'.
Now, I am able to delete the reference city 'Tirupur' in the City table. In the 'Adress' table, the field 'City' is empty. It goes against the rule that is setup, i.e. 'City' field is mandatory.
Where there is a reference to a master table, the record in the master table should not be allowed. Especially, when it the mandatory in the referring table, nullifying the field spoils the data integrity. Or, at least, if an option is to be given, system should at least ask whether to empty the referring table.
ARI