I have a Libre Office base set up for books and authors. Now I cannot add any more records. Can you please help.
Not knowing how you are trying to enter records (directly into table or through a created form) the most common problem is the Primary Key field in a table not set to Auto increment if you’re having the system generate the key. Based on your question it is not clear if you have one or more records already entered.
I have entered a list of over 400 books and authors by copying and pasting from Microsoft works 2003 Database. Now all of a sudden it will not let me add any more. I am not sure what you mean by the Primary Key field. Can you please help me. This is my first dealing with Libre Office.
A Primary Key field in a table is a unique piece of data for each record. For example you can use a Social Security number for a primary key field because each persons’ is different. However, a birth date is not unique since multiple people can have same date. When a unique field is not available, a field is set up as an Integer type and the property is set to Auto Value. This value is automatically incremented for each record entered. What message are you getting?
Also, copy/paste is probably not the best method. See:Import to LO Base. You can bring records into base either with spreadsheet data or dBase file - both of which I believe Works can output.
I am not getting any message. Having just loaded the base I suddenly find I can add to it at the bottom, but I can’t insert a record in the middle of the list ( inserting an extra line).
Records are always added at the end of a table. Sequence of entries is of no importance in a database. When records are retrieved they can be put in any sequence the user wishes.
Thanks for your help. Much appreciated.