[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

[libreoffice-users] Relationships in Base

2012-02-27 Thread gerbreown
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 message: SQL Status: 23000 Error code:

[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:

[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
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