Hi Don,
> When I try to establish the relationship as
> tlb_A.field1 = tbl_B.field1
>
> I get the following:
>
> SQL Status: 23000
> Error code: -177
>
> Integrity constraint violation - no parent 133, table: tbl_Survey2006 in
> statement [ALTER TABLE "tbl_Survey2006" ADD FOREIGN KEY ("biz_id")
> REFERENCES "tbl_BizContact" ("biz_id")]
I assume that in "tbl_Survey2006", you have a record with "biz_id"
beeing 133, but "tbl_BizContact" is missing a record with "biz_id" being
133. Thus, a relationship cannot be established, since for this
particular survey record, there's no contact record which it refers to.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
