Error "the changes you requested to the table were not successful because th.."?

  • I have three tables:
    1. Manufacturers
    2. Suppliers
    3. Linked table of both


    Attached the data model printscreen.


    When I try to insert data to form , I receive following error:
    "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 the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."


    What wrong?

  • Re: Error "the changes you requested to the table were not successful because th.."?


    Jonny


    The relationships look fine to me.


    How are you trying to add data?


    What properties have you set for MfrName and SupplierName in the link table?


    By the way why are you using MfrName and SupplierName as primary keys, why not use an Autonumber field to generate a arbritrary unique ID number?


    Also in the link table what type of field is UniqueID and what properties does it have?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!