更新\删除具有2个表格的Access数据库 [英] update\delete Access Database with 2 tabels

问题描述

大家好
我的Access数据库有2个表(表2链接到table1)
而table1包含供应商，而table2包含供应商和prudects
当我更新表1中显示的供应商消息时

{您请求对表的更改未成功，因为它们将在索引，主键或关系中创建重复的值.更改包含重复数据的一个或多个字段中的数据，删除索引，或将索引重新定义为允许重复的条目，然后重试.}

如何更新table1或table2中的供应商? 如果有人有通过MS Access使用拖曳表更新数据库的示例
谢谢您.

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

推荐答案

您需要准确执行消息告诉您的内容.您的数据库被设计为不允许重复，并且您正在尝试输入重复项.

You need to do exactly what the message is telling you. Your database is designed to not allow duplicates and you are trying to enter a duplicate.

这篇关于更新\删除具有2个表格的Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！