How to fix the no unique index found problem in laymen terms?

[Guest]

I'm trying to create a database for the first time. I have designed my tables
and I trying to create their relationships. I keep receiving the following
message: No unique index found for the referenced field of the primary table.
I'm not sure on how to fix this problm. Please explain in laymens terms. I'm
already confused enough.

Thanks!

 

[Kevin3NF]

Do you have a primary key defined in the "parent" table of the relatioship
you are trying to create? Access is telling you that you have not created a
way for the table to force uniqueness in the field you are trying to use to
relate this table to the other one

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Rick Brandt]

I'm trying to create a database for the first time. I have designed
my tables and I trying to create their relationships. I keep
receiving the following message: No unique index found for the
referenced field of the primary table. I'm not sure on how to fix
this problm. Please explain in laymens terms. I'm already confused
enough.

Thanks!

When you create relationships with Referential Integrity enforced then the
field on the "Main" side of the relationship must either be the Primary Key
of that table or have Unique Index applied to it. Just open the table in
design view and do one of those two things.

 

[Guest]

Yes, I have a primary key defined in the parent table - intCustomerID.

 

[Kevin3NF]

Is that the field you are creating the relationship on?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Guest]

Yes, but I fixed the problem. I did not have the primary keys labeled
correctly. Thanks for your help.