"Tom Ellison" wrote in
:

Are you talking about a 1:M relationship in which the foreign key
table is not indexed on the related column(s)? How can you
enforce uniqueness in the foreign table without a unique index?
But then you speak of HAVING a relationship without RI. Are you
speaking of a relationship in which both tables may have rows that
do not participate in the relationship? Without RI, you are
permitting that to happen!

I believe he was saying something very specific about Jet databases
and Access -- that when you create a relatinship, a hidden index is
created on the foreign key field.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/