Linking One Subform

[lmcc007]

I have attached a copy of my database in Access 2000. As I try to view the various e-mail addresses for companies, I keep getting this error message:

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Basically, all I am trying to do is view the record—not add a record. I looked at my table and I don’t have any duplicates. When I select the E-mail Type, I want it to display the e-mail address. Such as:

E-mail 2 = abc @ nol.net
E-mail 3 = cbs@ abc.com

I created a command button so if I need to add, revised, or delete an e-mail address it will be done in the CheckEmailAddresses form.


What am I doing wrong?

Thanks in advance for your help!

 

[HAMMAMABUARQOUB]

you are currently liknking the tables great, but the strnge thing you are using Email type as the subform not te EmailAdresses
I auggest you delete the subform...creat a new one based on Emailasddresses table, use the first option to link, and you will get a subform linke to the companies form with companyID field not email address type
Like this

 

[lmcc007]

That's not what I wanted. I get this when I select tblCompanies and hit create form. After continuing to try, I deleted the Control Source value and left Email Type as an unbound box and it is doing what I wanted, which is searching for an email type and then displaying the email address.

Thanks anyway.

 

[lmcc007]

Ooops, I spoke to soon. I keep getting an error with the unbound field.