Hi Don,
It seems that you have a value in one of the tables which isn't in the
other one.
You may create a query with a left join and see if every value on the
left side has a value from the other table.
Best regards,
Ocke
Don Parris wrote:
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
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
