O.k., I'm back with one more question. I have two tables, A & B. Both were
created by copying/pasting Calc sheets into Base.
tbl_A
-----
field1 = Primary Key
field2
field 3
tbl_B
-----
column1 = Primary Key
field1 = foreign key
Column2
Column3
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 have looked at a tutorial showing how to establish the relationship, but
when I do it with my two tables, it fails. Can someone assist?
Thanks in advance,
Don
