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?
It’s hard to tell with so little information.
Is there some possibility that there are data validation requirements you aren’t fulfilling?
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?
You MUST have a Primary Key, a unique index is not enough