I have two table
1- database
2- employees
both tables has primary key name ID , I set the primary key type in both table as BIGINT in mysql
in ASPrunner/advance security tab, I set "Users can see and edit their own data only" for both tables
for Employee table I set in ASPrunner/advance security tab "Users can see and edit their own data only" and usertable = OwnerID filed = ID also in the right side Main Table: OwnerID filed to ID
for Database table I set in ASPrunner/advance security tab "Users can see and edit their own data only" and usertable = OwnerID filed = ID also in the right side Main Table: OwnerID filed to ID
the problem after I add few record, I keep getting error Duplicate entry '1' for key 'PRIMARY'
please tell me where is the problem
I saw one post saying to use static security , not dynamic, but I need to give the admin panel to control the permissions, so this will not solve my problem, also I dropped all database and rebuild it again but still same issue.
regards.