On 8/30/06, Frank Schönheit - Sun Microsystems Germany <
[EMAIL PROTECTED]> wrote:

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.



Aha!  That's what the '133' refers to.  I'll look into that.  Thanks for the
input.

Reply via email to