Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: OpenOffice Database issue

07 Jan 2011   #1

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 
OpenOffice Database issue

After working with Access and SQL, I thought I'd try my hand at OpenOffice 3.1's "Base" program. Things went well creating tables and forms. What I was trying was to create a list of books I have in a library, including "Author", "Copyright Date", "Publisher", and "Price" (in case we should decide to sell them at any of our yard sales).

Here's my problem:

If I have more than one book from, say, John Grisham, I have a problem with entering the second book because the program spits an error regarding unique values in the "AuthorID" field. I know that this field, "Price" and the one for "CopyrightDate" will create duplicate values, and this error will get in the way.

Having seen this in Access and SQL, I know that I can change the properties of the field to allow duplicate entries, but I have no idea where to do that in Base. The Help function is no help to me.

It's probably a simple question to answer, but I need help, this time.

Thanx in advance.

My System SpecsSystem Spec
.

07 Jan 2011   #2

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

Would this be something you could use?

Quote:
Someimes when entering data one needs to create a number of records that are almost identical - in this case a copy record function would be useful.
Base - Copy column and copy row functions (View topic) • OpenOffice.org Community Forum
My System SpecsSystem Spec
07 Jan 2011   #3

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

My apologies in not being able to help you directly, I do use OOo, but not Base.

If you go to this OOo projects site documentation: Documents & files: Mid level Base tutorial
You will see a 1.07mb pdf Base Tutorial that may be of some help.
My System SpecsSystem Spec
.


08 Jan 2011   #4

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Anak View Post
Would this be something you could use?

Quote:
Someimes when entering data one needs to create a number of records that are almost identical - in this case a copy record function would be useful.
Base - Copy column and copy row functions (View topic) • OpenOffice.org Community Forum
Nah.... I'm not duplicating the field, just the value IN the field. Thanx though.
My System SpecsSystem Spec
08 Jan 2011   #5

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Anak View Post
My apologies in not being able to help you directly, I do use OOo, but not Base.

If you go to this OOo projects site documentation: Documents & files: Mid level Base tutorial
You will see a 1.07mb pdf Base Tutorial that may be of some help.
Actually, this DID help. I never got the chance to check out tutorials, or any of that, because I HAVE used the other two solutions. I just thought it would be easier to find that option.
My System SpecsSystem Spec
08 Jan 2011   #6

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

Glad I could help a little bit. Did the tutorial explain how to allow duplicate entries?
My System SpecsSystem Spec
09 Jan 2011   #7

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

PB4, your gonna get me to learn Base yet!

I was looking for a Calc/Xls solution, and found this, It may be easier to follow, not sure?:
Plan-B for OpenOffice.org Base - Table of Contents

Just scroll down the list click on a topic, and it will start a "screencast"
Hover the mouse cursor over any of the OOo icons to the left, and it covers all the sub-programs in OOo.

It says it's in a public-beta phase, but from what I can tell its been ongoing since 2006, but so far it's free.

WOT gives it a green.
My System SpecsSystem Spec
31 May 2011   #8

Windows 7 32 bit home premium
 
 
Index Field

My answer to this question is a little late, but thought I would throw this into the discussion anyway. An Open Office table needs to have an index field. This field contains a unique value to identify that particular record. It has to be UNIQUE. Usually, when setting up to table, OO will ask you if you want it to set up an index field. If you answer, yes, it will add a field and auto enter 1,2,3 etc as you enter data. If you answer, no, it will use the first field as the index. Thus, all entries in that field MUST be unique.
My System SpecsSystem Spec
31 May 2011   #9

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

Hi! nolakenoforest, welcome to 7F

Better late than never, added information can lead to clarity!

Correct me if I am wrong as I have limited knowledge of databases.
But, I believe what you are describing about the indexed fields is a requirement for any database in order for it to function properly, in returning useful information to the user.
My System SpecsSystem Spec
01 Jun 2011   #10

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by nolakenoforest View Post
My answer to this question is a little late, but thought I would throw this into the discussion anyway. An Open Office table needs to have an index field. This field contains a unique value to identify that particular record. It has to be UNIQUE. Usually, when setting up to table, OO will ask you if you want it to set up an index field. If you answer, yes, it will add a field and auto enter 1,2,3 etc as you enter data. If you answer, no, it will use the first field as the index. Thus, all entries in that field MUST be unique.
Quote   Quote: Originally Posted by Anak View Post
Hi! nolakenoforest, welcome to 7F

Better late than never, added information can lead to clarity!

Correct me if I am wrong as I have limited knowledge of databases.
But, I believe what you are describing about the indexed fields is a requirement for any database in order for it to function properly, in returning useful information to the user.
I thought I mentioned that. Yes, I did index the tables. I had a need to and indexed off of the ISBN number for the books in the library that I wanted.

In the meantime, it's a project I'll end up revisiting soon, as I've gotten pretty busy with other things since.

Thanx again for piping in, though. One day, SOMEONE will have the answers I seek. LOL
My System SpecsSystem Spec
Reply

 OpenOffice Database issue




Thread Tools



Similar help and support threads for2: OpenOffice Database issue
Thread Forum
Apache OpenOffice 4.0 has been released! Software
OpenOffice.org 3 Software
cv templates for OpenOffice Software
OpenOffice 3.2 Released Software
OpenOffice + Windows 7 Software
OpenOffice and Win 7 Software

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:59 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33