Unique Indexes

[elhamalireza]

HI every one:
What does this message stand for when attempting to make a One-To-Many relation between two fields of two separate tables.
"No unqiue Index found or..."
tnx very much

 

[dawnd3]

It means that it cannot tell what side is the ONE side. You need to make the ID field from the one side unique by setting it as a primary key. In table design, click on the ID field and click the primary key button (looks like a key.)

Dawn

http://www.calliopeconsulting.net

 

[elhamalireza]

Hey dawn:
Ofcourse, I had set the Primary keys for both side but...!

 

[lespaul]

Ok, the PK in one table needs to be a FK in the many table. The many table needs its OWN PK and that's NOT the one you link to in the relationship table:
[tt]

ManyTable
OneTable PK
PK<---------Relationship-------->OneTablePK
Other Field OtherField [/tt]

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[elhamalireza]

That's it.
Merci beaucoup

 

[hneal98]

If you have data in that field, it has duplicates.