Insert a record - via a form - PKEY error showing up across multiple reports


I have multiple reports in retool that I input a new record via a form by selecting on existing data in the table. In the past this has worked perfectly but recently across all my reports they are all starting to fail and show the following error -

"insert into Product Catalogue - PCF failed: you must satisfy the constraint 'Product Catalogue - PCF pkey'"

See image below and also preview before it fails. Any ideas?



I believe this may be because of your db's sequence. I found this link that may be useful to reset it and try if that is causing the error: