Table is duplicating on PK

[abraun]

We have a table that is duplicating on the primary key, we just noticed this issue starting to happen, the backend table is fine and I checked the Primary Key.



You are using DaDaBIK version 11.6-Elba enterprise, installed on 07-26-2022 (installation code: 0), the latest version of DaDaBIK is 11.7-Elba released on 08-18-2022

You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.

PHP Version: 7.3.11


sqlserver version: 15.00.4236
Web server: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.11
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.27

 

[eugenio]

It probably means you are joining another table (using a lookup field) setting in form configurator, as Lookup table primary key field, a field that is not a primary key.