使用主窗体中的两个子窗体创建的重复记录 [英] Duplicate records created using two subforms in a main form

问题描述

我在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.

推荐答案

wirejp，


这是重复在子窗体或子窗体下面的表格中记录？


根据您的子窗体链接到主窗体的方式，您可能只是查看预先存在的记录。 br />

请更好地解释发生了什么。

wirejp,

Is this a duplicate record in the subform or in the table beneath the subform?

Depending on how you have your subforms linked to your main form, you may just be looking at a pre-existing record.

Please explain better what is happening.

hi twinnyfo，


感谢您的快速回复。我可以将数据库文件和电子表格发送给您以获得帮助吗？如果是这样，请将您的电子邮件发送到我的收件箱。


我最终试图解决这个问题。我浏览网页寻求解决方案并查看YouTube视频以寻求帮助，但我不是更明智。

hi twinnyfo,

Thank you for your prompt response. Can I can send the database file and the spreadsheet to you for your assistance? If so, kindly send your email to my inbox.

I am at my wits end trying to figure this out. I have browsing the web for solutions and looking at youtube videos for help but I am no wiser.

不，你不能发送数据库，因为我无法在工作时打开它。另外，违反本网站的政策要求提供个人电子邮件地址。


如果您是新手，那没关系 - 我是一个，一次也是如此！


但是如果我们能够获得有关究竟发生了什么的更多信息，我们可以努力寻求解决方案。

No, you cannot send the db, as I can''t open it at work. Also it is a violation of this site''s policy to request personal e-mail addresses.

If you are a novice, that''s OK--I was one, once, too!

But we can work toward a solution if we get more information concerning what is exactly happening.

这篇关于使用主窗体中的两个子窗体创建的重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！