update\delete Access Database with 2 tabels

See more:

VB

MS-Access

database

Hi all
I have Access Database with 2 tables (table 2 linked to table1)
while table1 contain vendors and table2 contain vendor and prudects
when I update vendor in table 1 message shown

{"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."}

how I can update vendors in table1 or table2 ???
if anyone has an example to update database with tow tables with MS Access
thank you