Hi, I'm trying to create my first database and am trying to create a form
where I can create multiple contacts for one client, I've put in fake
information to try it out but everytime I try and save I get the error
message that my changes were not successful because they would create
duplicate values in the index, primary key or relationship. The only field
that is duplicated is the company name (which i choose from a drop down list)
and it is not indexed nor is is the primary key..... can someone please help?
I use Microsoft 2000 if that makes a difference

Please tell us the details about the tables you've created, the fields in
those tables, the form(s) that you're using, the properties for the combobox
that you're using, etc. The answer to your dilemma lies in the design
structure, but you need to tell us what that structure is, please.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"StBren" <(E-Mail Removed)> wrote in message
news:9D9B9F25-E6C7-4D13-943C-(E-Mail Removed)...
> Hi, I'm trying to create my first database and am trying to create a form
> where I can create multiple contacts for one client, I've put in fake
> information to try it out but everytime I try and save I get the error
> message that my changes were not successful because they would create
> duplicate values in the index, primary key or relationship. The only
> field
> that is duplicated is the company name (which i choose from a drop down
> list)
> and it is not indexed nor is is the primary key..... can someone please
> help?
> I use Microsoft 2000 if that makes a difference