问题描述
我在microsoft access 2010中创建了一个数据库，以显示不同国家/地区不同客户的发票。在这样做时，我使用主窗体中的两个子窗体创建。我使用了国家/地区名称将子表单链接到主表单。当我在特定国家/地区的子表单中输入新记录时，我意识到在子表单中创建了旧记录的重复记录。我该怎么做才能防止这种情况发生？我试图将主表单和子表单之间的查询链接更改为发票号。但是也出现了同样的问题。
P.S.我是微软访问2010的新手，任何帮助将不胜感激。
I have created a database in microsoft access 2010 to show invoices for different customers in different countries. In doing so, I created using a two subforms in a main form. I have used the "country name" to link the subforms to the main form. When I enter new records into the subforms for a specific country, I realized that a duplicate record of an old record are being created in the subforms. What can I do to prevent this from happening? I tried to change the query link between the main form and subform to "invoice number" but the same problem has occurred.
P.S. I am novice to microsoft access 2010 and any help will be greatly appreciated.
推荐答案
这篇关于使用主窗体中的两个子窗体创建的重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！