表单和子表单：主ID密钥不携带链接的子ID密钥 [英] Forms and Subforms: Master ID Key not carrying to linked Child ID Key

问题描述

再次问好。


我设置了一个链接到子窗体的主窗体（实际上是嵌套的子窗体，但顶层子窗体是给我带来麻烦的子窗体。）输入数据时，窗体都显示为有效正确地说，但是当您更改父/主表单中的记录时，表单丢失我们从子表单输入的所有数据。在检查表格后，我发现主密钥没有被填充到顶级子表单中，所以我怀疑这些记录只是消失了。因为它不知道将输入的先前记录与该主记录联系起来。


谢谢。

Elaina

Hello again.

I have setup a master form linked to a subform (actually nested subforms, but the top level subform is the one giving me trouble.) When entering data, the forms all appear to work correctly, but the moment that you change the record in the parent/master form, the forms "lose" all of the data we enter from the subforms. Upon examination of the tables, I found that the master key is not being populated into the top level subform, so I suspect that the records are simply "disappearing" because it doesn''t know to associate the previous records entered with that Master record.

Thanks.
Elaina

推荐答案

再次问好。


我设置了一个链接到子窗体的主窗体（实际上是嵌套的子窗体，但顶层子窗体是给我带来麻烦的子窗体。）输入数据时，窗体都显示为有效正确地说，但是当您更改父/主表单中的记录时，表单丢失我们从子表单输入的所有数据。在检查表格后，我发现主密钥没有被填充到顶级子表单中，所以我怀疑这些记录只是消失了。因为它不知道将输入的先前记录与该主记录联系起来。


谢谢。

Elaina

Hello again.

I have setup a master form linked to a subform (actually nested subforms, but the top level subform is the one giving me trouble.) When entering data, the forms all appear to work correctly, but the moment that you change the record in the parent/master form, the forms "lose" all of the data we enter from the subforms. Upon examination of the tables, I found that the master key is not being populated into the top level subform, so I suspect that the records are simply "disappearing" because it doesn''t know to associate the previous records entered with that Master record.

Thanks.
Elaina

也许我应该问一个问题？

如何让子子窗体拉出当前/所选记录的父ID？


谢谢。

Elaina

Perhaps I should ask a question?
How do I make the child subform pull the Parent ID for the current/selected record?

Thanks.
Elaina

再次问好。


我设置了一个链接到子窗体的主窗体（实际上是嵌套的子窗体，但顶层子窗体是给我带来麻烦的子窗体。）输入数据时，窗体都显示为有效正确地说，但是当您更改父/主表单中的记录时，表单丢失我们从子表单输入的所有数据。在检查表格后，我发现主密钥没有被填充到顶级子表单中，所以我怀疑这些记录只是消失了。因为它不知道将输入的先前记录与该主记录联系起来。


谢谢。

Elaina

Hello again.

I have setup a master form linked to a subform (actually nested subforms, but the top level subform is the one giving me trouble.) When entering data, the forms all appear to work correctly, but the moment that you change the record in the parent/master form, the forms "lose" all of the data we enter from the subforms. Upon examination of the tables, I found that the master key is not being populated into the top level subform, so I suspect that the records are simply "disappearing" because it doesn''t know to associate the previous records entered with that Master record.

Thanks.
Elaina

Elaina


这听起来更像是一段关系问题。子表单后面的表中的记录是否与主表单后面的表中的记录具有完全级联关系。换句话说，当添加新记录时，子表格中的外键会自动输入。


Mary

Elaina

This sound more like a relationship problem. Do the records in the table behind the subform have a fully cascading relationship with the records in the table behind the main form. In other words is the foreign key in the subforms table being entered automatically when a new record is being added.

Mary

Elaina


这听起来更像是一段关系问题。子表单后面的表中的记录是否与主表单后面的表中的记录具有完全级联关系。换句话说，当添加新记录时，子表格中的外键会自动输入。


Mary

Elaina

This sound more like a relationship problem. Do the records in the table behind the subform have a fully cascading relationship with the records in the table behind the main form. In other words is the foreign key in the subforms table being entered automatically when a new record is being added.

Mary

$ b $我很放心你问的那个。我做了检查，最初设置不正确。我解决了这个问题，它仍然无法正常工作。我需要做些什么才能刷新表格以应用改变？


谢谢。

I''m relieved that you asked that. I did check and it wasn''t set correctly initially. I fixed that and it''s still not working. Is there something that I need to do to refresh the forms to "apply" the change?

Thanks.

这篇关于表单和子表单：主ID密钥不携带链接的子ID密钥的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！