Persistent Duplicate Error in MySQL Despite Deleting and Re-adding Record

Here is the configuration of the set column values , which indeed sets the value to 2 in the user table rather than the P table. This occurs after the form submission, as seen in the previous screenshot where I did not add anything in the “ID field” of the additional columns in the form container for the P table.

Previously, I tried different approaches to manually add the “ID field,” but each attempt resulted in the same error. I also attempted to add a unique identifier, but the same error occurred. In one of my previous posts, you mentioned that using a Form Container (or any type of add form) will add a new row when it is submitted.

Reference to what you said :Need Help Syncing IDs Between MySQL and Glide Tables - #12 by Darren_Murphy

Therefore, my query is not about what happens after the form submission. I am trying to understand why my form is not submitting