Failed data integrity check

[DavidK]

Testing a Registration Form and just keep getting this... Failed data integrity check

 

Any suggestions??

[CoopperBackpack]

Hello @DavidK,

Usually this means that the 'Enforce referential integrity' option is enabled between the parent table and the child table.

For example:

 

 

And the Submission Form is created based on the child(related) table. The user tries to submit data to the child(related) table that does not exist in the parent table and this violates the referential integrity.

This article can be helpful https://howto.caspio.com/tables-and-views/relationships/relationship-settings/

 

[DavidK]

6 hours ago, CoopperBackpack said:

Hello @DavidK,

Usually this means that the 'Enforce referential integrity' option is enabled between the parent table and the child table.

For example:

 

 

And the Submission Form is created based on the child(related) table. The user tries to submit data to the child(related) table that does not exist in the parent table and this violates the referential integrity.

This article can be helpful https://howto.caspio.com/tables-and-views/relationships/relationship-settings/

 

Kind sir... I Truly respect and appreciate that. I have read it and (somewhat wondering how I understood it --- actually it was Ned's YouTube and Live Streams --- but I did) ... and You fixed or well helped me understand How to fix it here.

Thank You!! Thank You!! Thank You!!

David

 

[autonumber]

Hi! You could also check this post for more information