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.

--
View this message in context: 
http://nabble.documentfoundation.org/Relationships-in-Base-tp3780236p3780236.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@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

Reply via email to