relationship type: Indeterminate

[paul]

Hi,
For my Access 2000 application, I found out some of the
tables relationship type is changed from One to Many
to "Indeterminate". I don't know how it got changed? I
deleted the tables or removed the link, tried to created a
new one, but still the relationship type is :
Indeterminate. How can I restore the one to many
relationship?
Thanks for your help.

 

[Tim Ferguson]

How can I restore the one to many
relationship?

One end of the relationship must end on either a PK field(s) or at least
uniquely-indexed one.

One common catch with multi-field relationships is not picking up the
fields in the right order to match the index itself.

Hope that helps


Tim F

 

[Guest]

Thanks for the hint. Somehow I don't know when my other
end lost the primry key.