Re: [libreoffice-users] Re: Relationships in Base

2012-02-28 Thread Tom Davies
n Tue, 28/2/12, Dan Lewis wrote: From: Dan Lewis Subject: Re: [libreoffice-users] Re: Relationships in Base To: users@global.libreoffice.org Date: Tuesday, 28 February, 2012, 11:46 Tue, 2012-02-28 at 02:44 -0800, gerbreown wrote: > See my previous post on how I solved the problem. > >

Re: [libreoffice-users] Re: Relationships in Base

2012-02-28 Thread Dan Lewis
Tue, 2012-02-28 at 02:44 -0800, gerbreown wrote: > See my previous post on how I solved the problem. > > You suggested that I view Chpt 8 in the Getting Started Guide. Have done > that. > Question: Why is there NOT a separate guide for Base like there is for the > others, ie Writer,Calc,etc? > Q

[libreoffice-users] Re: Relationships in Base

2012-02-28 Thread Tom
Hi :) The separate Base Guide is being worked on but there is only about 1 person working on it with occasional help from 1 other person who does the proof-reading. You can see some of the draft chaters at http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Sorry

[libreoffice-users] Re: Relationships in Base

2012-02-28 Thread gerbreown
See my previous post on how I solved the problem. You suggested that I view Chpt 8 in the Getting Started Guide. Have done that. Question: Why is there NOT a separate guide for Base like there is for the others, ie Writer,Calc,etc? Question2: What are the parts of LO, ie Writer,Base,Calc called?

Re: [libreoffice-users] Re: Relationships in Base

2012-02-27 Thread Dan Lewis
On Mon, 2012-02-27 at 05:39 -0800, gerbreown wrote: > I used the Tools > Relationships and dragged/drug the field in one table to > the matching field in the other table, just like in MS Access. > > The second table was done the same way. > > I now have a lot of different tables with relationship

[libreoffice-users] Re: Relationships in Base

2012-02-27 Thread gerbreown
It looks like that when I renamed my new table to the old table the data got dropped. I am using combo-boxes and they showed the data so don't know why I was able to see the data. Maybe it was just the name and not the PK that was left in the table. But after reading your reply I looked at the ta

[libreoffice-users] Re: Relationships in Base

2012-02-27 Thread Andreas Säger
Am 27.02.2012 11:36, gerbreown wrote: I have just started using LO Base 3.4.4. I created 2 tables with a relationship between them. I then deleted one of the tables and created another one with a relationship to the first. When I try to add records to the table is gives me the following error

[libreoffice-users] Re: Relationships in Base

2012-02-27 Thread gerbreown
I used the Tools > Relationships and dragged/drug the field in one table to the matching field in the other table, just like in MS Access. The second table was done the same way. I now have a lot of different tables with relationships between them. When I create the forms for data entry to these

[libreoffice-users] Re: Relationships in Base

2012-02-27 Thread gerbreown
I just created another form and when I try to enter data I get the following error message: "Integrity constraint violation - no parent SYS_FK_81 table" Does anyone know where these SYS*** tables are and how they can be deleted??? Thanks -- View this message in context: http://nabble.documentfo