Re: [libreoffice-users] Relationships in Base

On Mon, 2012-02-27 at 02:36 -0800, 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 message: "SQL Status: 23000
> Error code: -177
>
> Integrity constraint violation - no parent SYS_FK_110 table:  Patient Old in
> statement [INSERT INTO "Pharm Rcpt" (
> "pr_Cost","pr_Date","pr_Doctor","pr_Med","pr_Patient","pr_Pharm","pr_Qty")
> VALUES ( ?,?,?,?,?,?,?)]"
>
> It looks like the relationship did not get deleted when the table was
> deleted.

     When you have the database opened, use
       Tools > Relationships 
to define relationships between tables or to delete relationships.
     What I would like to know is the specific steps you used to create
the relationship between the two tables? How did you add the second
relationship you mentioned?

--Dan




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted