Ask Your Question

Cannot get records to add in Base even after adding unique index

asked 2015-01-27 17:12:23 +0200

Rags57 gravatar image

I am converting some tables from Access to Base. I do not want to have a primary key created on the table so I created a unique index in Base after I imported the table. I am still unable to add records to the table even though I have a unique index defined for the table. What am I doing wrong?

edit retag flag offensive close merge delete


It's hard to tell with so little information.

Is there some possibility that there are data validation requirements you aren't fulfilling?

Wildcard gravatar imageWildcard ( 2015-01-31 05:15:43 +0200 )edit

could the file be read only? did you close LO and restart? is there a foreign key? did you input data into the primary key column?

doug gravatar imagedoug ( 2015-01-31 06:21:11 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-05-16 23:50:19 +0200

Michel_1495 gravatar image

You MUST have a Primary Key, a unique index is not enough

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-27 17:12:23 +0200

Seen: 94 times

Last updated: May 16 '16