复制控制 [英] Copy Control

问题描述

大家好，


我正在尝试在我的表单''frm_initialProperty'上开发一个控制按钮，它将复制我的tbl_customer表中的联系地址（5个字段）到我的tbl_properties表。


表单显示在先前表单上输入的客户的联系地址。我想要一个按钮将这些数据复制到同一表单上的属性地址字段中。我使用了以下代码:(但是我得到一个错误''你不能为这个对象赋值''）

展开 | 选择 | 换行 | 行号

解决方案

所有你需要做的*最多*将此客户的PrimaryKey作为ForeignKey放在Property表的tbl_customer表中。

< blockquote>有时（通常用于审计目的）实际上有必要复制信息。然而，这很少见。为了简单地访问数据，链接通常更好。请阅读规范化和表格结构以获得更全面的解释。


如果您可以解释离开的地方，我们可以在必要时继续。

您好，


我已将我的数据标准化为第3个NF。但是，我需要将此数据复制到将用于报告的临时表。任何有关如何创建复制控制按钮的帮助都会很棒。


谢谢

Jane

Hi All,

I''m trying to develop a control button on my form ''frm_initialProperty'' that will copy a contact address (5 fields) from my tbl_customer table to my tbl_properties table.

The form shows a contact address for a customer that was input on a previous form. I would like a button to copy this data into the property address fields on the same the form. I have used the following code: (however I get an error ''You can''t assign a value to this object'')

Expand|Select|Wrap|Line Numbers

解决方案

All you should need to do *at most* is put the PrimaryKey for this customer in the tbl_customer table in the Property table as a ForeignKey.

Sometimes (generally for auditing purposes) it is necessary actually to copy information. This is rare however. For simple access to the data a link is generally better. Please read Normalisation and Table structures for a fuller explanation.

If you could perhaps explain where that leaves you, we can continue if necessary.

Hi There,

I have normalised my data to 3rd NF. However I need to copy this data to a temp table that will be used for reporting. Any help with how I can create a copy control button would be great.

Thanks
Jane

这篇关于复制控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！