Ask Your Question
0

How can I add a record to database

asked 2016-03-24 20:44:03 +0100

Muddle gravatar image

I have a Libre Office base set up for books and authors. Now I cannot add any more records. Can you please help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-03-24 21:12:06 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

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.

Muddle gravatar imageMuddle ( 2016-03-26 20:42:57 +0100 )edit

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?

Ratslinger gravatar imageRatslinger ( 2016-03-26 22:45:28 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2016-03-26 23:16:50 +0100 )edit

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).

Muddle gravatar imageMuddle ( 2016-03-30 21:11:47 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2016-03-30 21:55:57 +0100 )edit

Thanks for your help. Much appreciated.

Muddle gravatar imageMuddle ( 2016-03-31 21:24:26 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-24 20:44:03 +0100

Seen: 1,134 times

Last updated: Mar 24 '16