Hello All,

Could someone please explain to me what the settings in the Foreign Key Integrity are:

• none
• reset
• cascade

That might help me better understand what I am doing when using a FK.

Kind Regards,

Edward

Hi Edward,

I think the explanation under the question mark in the builder is already clear:
None : Keep object with his broken key.
Reset : set to 0.
Cascade : delete all objects from this table that refers to it.

An example with two tables:
TableA
TableB: Foreign key TableA_id.

If you delete in TableA a record with TableA_id value 1 the process is:
None:
Records in TableB keeps there reference to TableA_id 1. A result could be that views will not work or at least misses data from TableA because the record does not exist anymore.

Reset:
Records in TableB with TableA_id value 1 will be reset to 0. Same result as above but it is easier to capture the 'wrong' records.

Cascade:
Records in TableB with TableA_id value 1 will be deleted. Dangerous because all records with the TableA_id reference will be deleted in TableB. Important to build in a warning or an extra confirmation of the user.

Hope this will help you.

Best Regards,
Adriaan

Big Thanks Adriaan,

Damn that elusive Question Mark help symbol I keep forgetting about.
Your explanation is clear and concise. Much appreciated.

Regards,

Edward

And for the moment, Cook don't ask you anything before to process. It is only an automatism when you are sure of what you do. If not, don't allow final user to delete.